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

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;