select l.column_name , l.nullable , l.data_type , t.comments
from cols l , all_col_comments t
where t.column_name = l.column_name
and t.table_name = l.table_name
and t.table_name = '<yourtable>';
from cols l , all_col_comments t
where t.column_name = l.column_name
and t.table_name = l.table_name
and t.table_name = '<yourtable>';
Describe 表名
就能得到
SELECT x.column_name "Name", x.nullable "Null?"
, x.data_type || '(' || x.data_length || ')' "Type", y.comments
FROM cols x, user_col_comments y
WHERE x.table_name = 'TABLE1'
AND x.table_name = y.table_name(+)
AND x.column_name = y.column_name(+)