Query 1:
select column_name, data_type, data_length,
2 data_precision, data_scale from ALL_TAB_COLUMNS
3 where table_name = 'EMP';
Query 2:
SQL> set long 100000
SQL> set pages 0
Type: Posts; User: nwinkumar; Keyword(s):
Query 1:
select column_name, data_type, data_length,
2 data_precision, data_scale from ALL_TAB_COLUMNS
3 where table_name = 'EMP';
Query 2:
SQL> set long 100000
SQL> set pages 0