DBA Data[Home] [Help]

VIEW: SYS.EXU7REFI

Source

View Text - Preformatted

SELECT "OBJID","OWNER","OWNERID","TNAME","ROWNER","RTNAME","CNAME","CNO","RCNO","ACTION","ENABLED" from sys.exu7ref
       WHERE (ownerid, tname) in (SELECT ownerid, name from sys.exu7tabi)

View Text - HTML Formatted

SELECT "OBJID"
, "OWNER"
, "OWNERID"
, "TNAME"
, "ROWNER"
, "RTNAME"
, "CNAME"
, "CNO"
, "RCNO"
, "ACTION"
, "ENABLED"
FROM SYS.EXU7REF
WHERE (OWNERID
, TNAME) IN (SELECT OWNERID
, NAME
FROM SYS.EXU7TABI)