DBA Data[Home] [Help]
Skip to content

VIEW: SYS.USER_OPERATOR_COMMENTS

Source

View Text - Preformatted

select u.name, o.name, c.comment$
from   sys.obj$ o, sys.operator$ op, sys.com$ c, sys.user$ u
where  o.obj# = op.obj# and c.obj# = op.obj# and u.user# = o.owner#
       and o.owner# = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, C.COMMENT$ FROM SYS.OBJ$ O
, SYS.OPERATOR$ OP
, SYS.COM$ C
, SYS.USER$ U WHERE O.OBJ# = OP.OBJ#
AND C.OBJ# = OP.OBJ#
AND U.USER# = O.OWNER#
AND O.OWNER# = USERENV('SCHEMAID')