DBA Data[Home] [Help]

VIEW: SYS.EXU7TGRC

Source

View Text - Preformatted

SELECT "OWNERID","OWNER","BASEOBJECT","BASEOBJOWNER","DEFINITION","WHENCLAUSE","ACTIONSIZE","ACTION","ENABLED","NAME","BASENAME" from sys.exu7tgr 
	WHERE (ownerid, basename) in (SELECT ownerid, name from sys.exu7tabc)

View Text - HTML Formatted

SELECT "OWNERID"
, "OWNER"
, "BASEOBJECT"
, "BASEOBJOWNER"
, "DEFINITION"
, "WHENCLAUSE"
, "ACTIONSIZE"
, "ACTION"
, "ENABLED"
, "NAME"
, "BASENAME"
FROM SYS.EXU7TGR WHERE (OWNERID
, BASENAME) IN (SELECT OWNERID
, NAME
FROM SYS.EXU7TABC)