在Oracle库中查找所有表的相关信息

 select o.name, c.name, co.comment$ ---表明，字段名，字段注释from sys.obj$ o, sys.col$ c, sys.com$ cowhere o.owner# = userenv('SCHEMAID')  and o.type# in (2, 4)  and o.obj# = c.obj#  and c.obj# = co.obj#(+)  and c.intcol# = co.col#(+)  and bitand(c.property, 32) = 0 /* not hidden column */;comment on column sys.USER_COL_COMMENTS.TABLE_NAME is 'Object name';comment on column sys.USER_COL_COMMENTS.COLUMN_NAME is 'Column name';comment on column sys.USER_COL_COMMENTS.COMMENTS is 'Comment on the column';