SQL> select column_name, data_type, data_length, 2 data_precision, data_scale from ALL_TAB_COLUMNS 3* where table_name = 'EMP';
