oracle中列出用户下的所有表的列和列的描述

视图为：

create or replace view sys.user_col_comments as
select o.name, c.name, co.comment$
from sys."_CURRENT_EDITION_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

 

查询视图

select * from user_col_comments

结果为：

表名   列名  列名描述