DBA Data[Home] [Help]

VIEW: SYS.EXU7PSTIC

Source

View Text - Preformatted

SELECT "OWNER","OWNERID","TNAME","TOBJID","CALLORDER" from sys.exu7pst
		WHERE (ownerid, tname) in
	        (SELECT i.owner#, i.name
                 FROM sys.incexp i, sys.incvid v
                 WHERE i.expid > v.expid AND i.type# = 2)

View Text - HTML Formatted

SELECT "OWNER"
, "OWNERID"
, "TNAME"
, "TOBJID"
, "CALLORDER"
FROM SYS.EXU7PST WHERE (OWNERID
, TNAME) IN (SELECT I.OWNER#
, I.NAME
FROM SYS.INCEXP I
, SYS.INCVID V
WHERE I.EXPID > V.EXPID
AND I.TYPE# = 2)