create or replace view sys.user_col_comments as
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 */;
#通常表示是一组id
$不是很了解,大概作为语义上的标识符。$前有的是用户,有的是级别,有的是对象。你可以查询select * from all_tables where table_name like '%$%'找一下规律