查询表字段明细
select column_name,data_type,data_length,data_precision,data_scale from all_tab_columns where table_name='表名'
字段注释
select * from user_col_comments;
根据表名查询表字段注释
select * from user_col_comments where TABLE_NAME = '表名';
查询所有表注释
select * from user_tab_comments;
根据表名查询表注释
select * from user_tab_comments where TABLE_NAME = '表名';
select column_name,data_type,data_length,data_precision,data_scale from all_tab_columns where table_name='表名'
字段注释
select * from user_col_comments;
根据表名查询表字段注释
select * from user_col_comments where TABLE_NAME = '表名';
查询所有表注释
select * from user_tab_comments;
根据表名查询表注释
select * from user_tab_comments where TABLE_NAME = '表名';