Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

Set long 50000

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>