1
2
3
4
5
6
7
8
9
select t.column_name, data_type as column_type, 
  data_length as column_size, comments as description
from all_tab_columns t, all_col_comments c
where t.table_name = c.table_name
and t.column_name = c.column_name
and t.owner = c.owner
and t.owner = 'schema_name' -- ommit for all schemas :)
and t.table_name = 'table_name'
ORDER BY COLUMN_ID;