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), ' ')); …