查询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】
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】