VIEW: SYS.EXU9MVLU

Source

View Text - Preformatted

SELECT  "CTOBJ#","LOG_OWNER","LOG_NAME","LOG_OWNERID","CREATED_TIME","FILE_VERSION","USING_ROWID_FLAG","USING_PRIMARYKEY_FLAG","USING_OID_FLAG","USING_SEQUENCE_FLAG","CHANGE_SET_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","CREATED_SCN","MVL_FLAG","CAPTURED_VALUES","MVL_TEMP_LOG","MVL_V7TRIGGER","LAST_ALTERED","LOWEST_SCN","MVL_OLDEST_RID","MVL_OLDEST_PK","MVL_OLDEST_OID","MVL_OLDEST_NEW","MVL_OLDEST_RID_TIME","MVL_OLDEST_PK_TIME","MVL_OLDEST_OID_TIME","MVL_OLDEST_NEW_TIME","MVL_BACKCOMPAT_VIEW","MVL_PHYSMVL","HIGHEST_SCN","HIGHEST_TIMESTAMP"
        FROM    sys.exu9mvl
        WHERE   log_ownerid = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT "CTOBJ#"
, "LOG_OWNER"
, "LOG_NAME"
, "LOG_OWNERID"
, "CREATED_TIME"
, "FILE_VERSION"
, "USING_ROWID_FLAG"
, "USING_PRIMARYKEY_FLAG"
, "USING_OID_FLAG"
, "USING_SEQUENCE_FLAG"
, "CHANGE_SET_NAME"
, "SOURCE_SCHEMA_NAME"
, "SOURCE_TABLE_NAME"
, "CREATED_SCN"
, "MVL_FLAG"
, "CAPTURED_VALUES"
, "MVL_TEMP_LOG"
, "MVL_V7TRIGGER"
, "LAST_ALTERED"
, "LOWEST_SCN"
, "MVL_OLDEST_RID"
, "MVL_OLDEST_PK"
, "MVL_OLDEST_OID"
, "MVL_OLDEST_NEW"
, "MVL_OLDEST_RID_TIME"
, "MVL_OLDEST_PK_TIME"
, "MVL_OLDEST_OID_TIME"
, "MVL_OLDEST_NEW_TIME"
, "MVL_BACKCOMPAT_VIEW"
, "MVL_PHYSMVL"
, "HIGHEST_SCN"
, "HIGHEST_TIMESTAMP"
FROM SYS.EXU9MVL
WHERE LOG_OWNERID = USERENV('SCHEMAID')