Oracle数据字典常用查询

 Oracle数据字典常用查询
--查看当前用户所有表及描述
select o.object_name,c.comments
from user_objects o
left outer join user_tab_comments  c
on o.object_name=c.table_name
where object_type='TABLE'
and c.comments like '%项目%'
 
--查看当前用户所有字段信息及描述
select c.table_name,o.column_name,o.data_type,o.data_length,c.comments
from user_tab_columns o
left outer join user_col_comments c
on o.TABLE_NAME=c.table_name
and  o.COLUMN_NAME=c.column_name
where o.table_name like upper('OM_ORGANIZATION%')