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%')