查询表
select t.* from user_tables t where t.table_name='tablename';
查询表字列
select * from user_tab_columns c where c.TABLE_NAME='tablename';
查询注释
select cs.column_name,cs.comments from user_col_comments cs where cs.table_name='tablename';
查询表
select t.* from user_tables t where t.table_name='tablename';
查询表字列
select * from user_tab_columns c where c.TABLE_NAME='tablename';
查询注释
select cs.column_name,cs.comments from user_col_comments cs where cs.table_name='tablename';