Search This Blog

Tuesday, May 22, 2018

Remove Enter/Newline from a String By PL/SQL



DECLARE
   temp   VARCHAR2 (32767) := 'This is a string using
ENTER button. ';
BEGIN
   DBMS_OUTPUT.put_line (temp);
   DBMS_OUTPUT.put_line (
      REPLACE (REPLACE (temp, CHR (13), ''), CHR (10), ' '));
END;

No comments:

Post a Comment

Search String Inside Oracle Database Objects SQL

SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;