DBA Data[Home] [Help]

VIEW: SYS.EXU10SNAPLU

Source

View Text - Preformatted

SELECT  "LOG_OWNER","LOG_OWNERID","MASTER","LOG_TABLE","LOG_TRIGGER","FLAG","YOUNGEST","OLDEST","OLDEST_PK","MTIME","ROWID_SNAPL","PRIMKEY_SNAPL","OID_SNAPL","SEQ_SNAPL","INV_SNAPL","FILE_VER","TEMP_LOG","OLDEST_OID","OLDEST_NEW","OLDEST_SEQ"
        FROM    sys.exu10snapl
        WHERE   log_ownerid = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT "LOG_OWNER"
, "LOG_OWNERID"
, "MASTER"
, "LOG_TABLE"
, "LOG_TRIGGER"
, "FLAG"
, "YOUNGEST"
, "OLDEST"
, "OLDEST_PK"
, "MTIME"
, "ROWID_SNAPL"
, "PRIMKEY_SNAPL"
, "OID_SNAPL"
, "SEQ_SNAPL"
, "INV_SNAPL"
, "FILE_VER"
, "TEMP_LOG"
, "OLDEST_OID"
, "OLDEST_NEW"
, "OLDEST_SEQ"
FROM SYS.EXU10SNAPL
WHERE LOG_OWNERID = USERENV('SCHEMAID')