set long 50000 : Long « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






SQL>
SQL>
SQL> set long 50000
SQL>
SQL> select text
  2    from all_views
  3   where view_name = 'ALL_TAB_COLUMNS'
  4  /


TEXT
--------------------------------------------------------------------------------
select /*+ rule */ OWNER, TABLE_NAME,
       COLUMN_NAME, DATA_TYPE, DATA_TYPE_MOD, DATA_TYPE_OWNER,
       DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, COLUMN_ID,
       DEFAULT_LENGTH, DATA_DEFAULT, NUM_DISTINCT, LOW_VALUE, HIGH_VALUE,
       DENSITY, NUM_NULLS, NUM_BUCKETS, LAST_ANALYZED, SAMPLE_SIZE,
       CHARACTER_SET_NAME, CHAR_COL_DECL_LENGTH,
       GLOBAL_STATS, USER_STATS, AVG_COL_LEN, CHAR_LENGTH, CHAR_USED,
       V80_FMT_IMAGE, DATA_UPGRADED, HISTOGRAM
  from ALL_TAB_COLS
 where HIDDEN_COLUMN = 'NO'


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