Site icon An Oracle Spin by Alex Lima

Set default number of bytes to display LONG and CLOB

To change default number of bytes to be displayed when selecting LONG and CLOB columns.
SQL> SET LONG 2000
SQL> SELECT long_column, clob_column FROM table_name;

Exit mobile version