select utc.TABLE_NAME,
utc.column_name,
utc.data_type,
utc.data_length,
utc.data_precision,
utc.data_Scale,
utc.nullable,
utc.data_default,
ucc.comments
from user_tab_columns utc, user_col_comments ucc
where
utc.table_name = ucc.table_name
and utc.column_name = ucc.column_name
utc.column_name,
utc.data_type,
utc.data_length,
utc.data_precision,
utc.data_Scale,
utc.nullable,
utc.data_default,
ucc.comments
from user_tab_columns utc, user_col_comments ucc
where
utc.table_name = ucc.table_name
and utc.column_name = ucc.column_name