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

 select o.name, c.name, co.comment$ ---表明，字段名，字段注释
from sys.obj$ o, sys.col$ c, sys.com$ co
where 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';