欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

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

程序员文章站 2024-01-17 09:09:46
...
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】