LONG controls how much of a LONG or CLOB sqlplus displays by default : Long « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. Long
SQL>
SQL> Set long 5000
SQL>
SQL>








29.13.Long
29.13.1.LONG controls how much of a LONG or CLOB sqlplus displays by default
29.13.2.Set long
29.13.3.set long 999
29.13.4.set long 50000