SELECT /*+ all_rows */
o.name, r.condition, bu.name, bo.name, r.r_action, r.r_comment
FROM rule$ r, obj$ o, obj$ bo, user$ bu
WHERE r.obj# = o.obj# and o.owner# = USERENV('SCHEMAID') and
r.ectx# = bo.obj#(+) and bo.owner# = bu.user#(+)
SELECT /*+ ALL_ROWS */
O.NAME
, R.CONDITION
, BU.NAME
, BO.NAME
, R.R_ACTION
, R.R_COMMENT
FROM RULE$ R
, OBJ$ O
, OBJ$ BO
, USER$ BU
WHERE R.OBJ# = O.OBJ#
AND O.OWNER# = USERENV('SCHEMAID') AND
R.ECTX# = BO.OBJ#(+)
AND BO.OWNER# = BU.USER#(+)
|
|
|