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')