Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Output varchar variable

SQL> SQL> DECLARE   2     v_string VARCHAR2(500 CHAR);   3  BEGIN   4     DBMS_OUTPUT.PUT(CHR(10));   5     DBMS_OUTPUT.PUT_LINE('releases');   6     DBMS_OUTPUT.PUT(CHR(10));   7     v_string := 'y''ve '||'recognize this, often ...';   8     DBMS_OUTPUT.PUT_LINE(v_string);   9  END;  10  / releases y've recognize this, often ... PL/SQL procedure successfully completed. SQL>