How to Remove New line from a String Using PL/SQL/ORACLE?

  • To Remove New line from the string:
DECLARE
   p_sting   VARCHAR2 (100) := 'This is Vikas from Delhi
Now the next line. ';
BEGIN
   DBMS_OUTPUT.put_line (p_sting);
   DBMS_OUTPUT.put_line (
      REPLACE (REPLACE (p_sting, CHR (13), ''), CHR (10), ' '));
END;