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

Java to Oracle database Connection Using JDBC

Oracle database. // Java Program to Establish Connection  // in JDBC with Oracle Database // Importing database import java.sql.*; // Import...