select column_name, data_type, data_length, nullable from all_tab_columns where table_name = 'table_name' order by column_id;
