SELECT /*+ all_rows */
u.name, o.name, bu.name, bo.name, r.rs_comment
FROM rule_set$ r, obj$ o, user$ u, obj$ bo, user$ bu
WHERE r.obj# = o.obj# and u.user# = o.owner#
and r.ectx# = bo.obj#(+) and bo.owner# = bu.user#(+)
SELECT /*+ ALL_ROWS */
U.NAME
, O.NAME
, BU.NAME
, BO.NAME
, R.RS_COMMENT
FROM RULE_SET$ R
, OBJ$ O
, USER$ U
, OBJ$ BO
, USER$ BU
WHERE R.OBJ# = O.OBJ#
AND U.USER# = O.OWNER#
AND R.ECTX# = BO.OBJ#(+)
AND BO.OWNER# = BU.USER#(+)
|
|
|