/ #ORACLE #PLSQL 

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

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

Preview

  • 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;