all \dba\ user
select 'create table '||t.TABLE_NAME||' ();' from all_tab_columns t where t.OWNER in ('LIMS_DICT','LIMS_DATA');
表示查询所有表和列
dba
select 'create table '||t2.TABLE_NAME||' ();' from dba_tab_comments t2 where t2.OWNER in ('LIMS_DICT','LIMS_DATA') and table_name not like 'BIN%';
表示查询数据库里面的表和描述
tab:表
comments:描述
user
select * from user_col_comments t1 where t1.OWNER in ('LIMS_DICT','LIMS_DATA');
表示查询所有用户