SELECT "LOG_OWNER","LOG_OWNERID","MASTER","LOG_TABLE","LOG_TRIGGER","FLAG","YOUNGEST","OLDEST","OLDEST_PK","MTIME","ROWID_SNAPL","PRIMKEY_SNAPL","FILE_VER"
FROM sys.exu8snapl
WHERE log_ownerid = userenv('SCHEMAID')
SELECT "LOG_OWNER"
, "LOG_OWNERID"
, "MASTER"
, "LOG_TABLE"
, "LOG_TRIGGER"
, "FLAG"
, "YOUNGEST"
, "OLDEST"
, "OLDEST_PK"
, "MTIME"
, "ROWID_SNAPL"
, "PRIMKEY_SNAPL"
, "FILE_VER"
FROM SYS.EXU8SNAPL
WHERE LOG_OWNERID = USERENV('SCHEMAID')
|
|
|