查询Oracle中某张指定表的列的信息

select a.owner,
        a.table_name,
        a.column_name,
        a.data_type,
        a.data_length,
        a.data_precision,
        a.data_scale,
        a.nullable,
        a.segment_column_id,
        a.internal_column_id,
        a.column_id,
        a.last_analyzed,
        a.num_nulls,
        b.comments
   from all_tab_cols a, all_col_comments b
where a.table_name = b.table_name
    and a.owner = b.owner
    and a.column_name = b.column_name
    and a.table_name = upper('your_table_name');


【编写于 2009-01-23】