Descript Tables Schema

select
tbc.OWNER , tbc.TABLE_NAME as TableName, tbc.COLUMN_NAME as ColumnName, tbc.COLUMN_ID , '' as PK ,
Case When LENGTH(tbc.Data_precision) >=1 then tbc.DATA_TYPE||'('||tbc.DATA_Precision||','||tbc.DATA_Scale||')'
else tbc.DATA_TYPE||'('||tbc.DATA_LENGTH||')' End as DataType,
tbc.DATA_DEFAULT as Def , tbm.COMMENTS as Description
from All_TAB_COLUMNS tbc , All_col_COMMENTS tbm
where tbc.table_name = 'TABLE_NAME' and tbc.owner ='OWNER' and tbc.OWNER = tbm.OWNER and tbc.TABLE_NAME = tbm.TABLE_NAME
and tbm.column_name = tbc.column_name
order by tbc.COLUMN_ID