VIEW: SYS.INT$DBA_COL_COMMENTS

Source

View Text - Preformatted

select u.name, o.name, o.obj#, o.type#, c.name, co.comment$,
       decode(bitand(o.flags, 196608), 65536, 1, 131072, 1, 0),
       to_number(sys_context('USERENV', 'CON_ID'))
from sys."_CURRENT_EDITION_OBJ" o, sys.col$ c, sys.user$ u, sys.com$ co
where o.owner# = u.user#
  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 */
  and (sys_context('USERENV', 'CON_ID') <= 1 or
       bitand(o.flags, 196608) = 0)

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, O.OBJ#
, O.TYPE#
, C.NAME
, CO.COMMENT$
, DECODE(BITAND(O.FLAGS
, 196608)
, 65536
, 1
, 131072
, 1
, 0)
, TO_NUMBER(SYS_CONTEXT('USERENV'
, 'CON_ID')) FROM SYS."_CURRENT_EDITION_OBJ" O
, SYS.COL$ C
, SYS.USER$ U
, SYS.COM$ CO WHERE O.OWNER# = U.USER#
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 */
AND (SYS_CONTEXT('USERENV'
, 'CON_ID') <= 1 OR BITAND(O.FLAGS
, 196608) = 0)