Output varchar variable : DBMS_OUTPUT « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_OUTPUT
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>
SQL>
SQL>








31.17.DBMS_OUTPUT
31.17.1.DBMS_OUTPUT.CHARARR
31.17.2.q for quotation with []
31.17.3.Output character or line
31.17.4.Output varchar variable
31.17.5.EXECUTE DBMS_OUTPUT.ENABLE(10000)
31.17.6.Use DBMS_OUTPUT.PUT_LINE to output clob data
31.17.7.Use DBMS_OUTPUT.PUT_LINE to output the table collection indexed by BINARY_INTEGER
31.17.8.Call substr in DBMS_OUTPUT.PUT_LINE
31.17.9.Output Visual line break
31.17.10.dbms_output.new_line
31.17.11.Output employee name with pl/sql, cursor and dbms_output.put_line