DBA Data[Home] [Help]

VIEW: IMC.IMC_RECENT_ACCESSED_OBJ#

Source

View Text - Preformatted

select ACCESS_ID ACCESS_ID, USER_ID USER_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, OBJECT_NAME OBJECT_NAME, APPLICATION_ID APPLICATION_ID, DATE_CREATED DATE_CREATED, ADDITIONAL_VALUE1 ADDITIONAL_VALUE1, ADDITIONAL_VALUE2 ADDITIONAL_VALUE2, ADDITIONAL_VALUE3 ADDITIONAL_VALUE3, ADDITIONAL_VALUE4 ADDITIONAL_VALUE4, ADDITIONAL_VALUE5 ADDITIONAL_VALUE5, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "IMC"."IMC_RECENT_ACCESSED_OBJ"
View Text - HTML Formatted

SELECT ACCESS_ID ACCESS_ID
, USER_ID USER_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, OBJECT_NAME OBJECT_NAME
, APPLICATION_ID APPLICATION_ID
, DATE_CREATED DATE_CREATED
, ADDITIONAL_VALUE1 ADDITIONAL_VALUE1
, ADDITIONAL_VALUE2 ADDITIONAL_VALUE2
, ADDITIONAL_VALUE3 ADDITIONAL_VALUE3
, ADDITIONAL_VALUE4 ADDITIONAL_VALUE4
, ADDITIONAL_VALUE5 ADDITIONAL_VALUE5
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "IMC"."IMC_RECENT_ACCESSED_OBJ"