oracle查看該用戶的所有表名字、表注釋、字段名、字段注釋、是否為空、字段類型
來源：程序員人生 發(fā)布時間：2014-11-09 09:43:19 閱讀次數(shù)：4186次
--oracle查看該用戶的所有表名字、表注釋、字段名、字段注釋、是不是為空、字段類型
select distinct TABLE_COLUMN.*,
TABLE_NALLABLE.DATA_TYPE,
TABLE_NALLABLE.NULLABLE
from (select distinct utc.table_name table_name,
utc.comments table_comments,
ucc.column_name column_name,
ucc.comments column_comments
from user_tab_comments utc, user_col_comments ucc
where utc.table_name = ucc.table_name
and utc.table_name not like '%_B'
and utc.table_name not like '%_Z'
and utc.table_name not like '%1%') TABLE_COLUMN,
(select distinct table_name, column_name, nullable, DATA_TYPE
from user_tab_cols
where table_name not like '%_B'
and table_name not like '%_Z'
and table_name not like '%1%') TABLE_NALLABLE
where TABLE_COLUMN.column_name = TABLE_NALLABLE.column_name
and TABLE_COLUMN.TABLE_NAME = TABLE_NALLABLE.table_name
--and TABLE_COLUMN.column_comments like '%分類名稱%'
and TABLE_COLUMN.table_comments like '%字典%';
--屢次去掉笛卡爾
生活不易，碼農(nóng)辛苦
如果您覺得本網(wǎng)站對您的學(xué)習(xí)有所幫助,可以手機掃描二維碼進行捐贈
