oracle apex view logs
SELECT adb.APEX_USER,
adb.APPLICATION_ID, wal.APPLICATION_NAME, adb.PAGE_ID,
adb.MESSAGE, adb.MESSAGE_TIMESTAMP,
adb.PAGE_VIEW_ID, adb.SESSION_ID
FROM APEX_WORKSPACE_ACTIVITY_LOG wal
INNER JOIN APEX_DEBUG_MESSAGES adb
ON wal.DEBUG_PAGE_VIEW_ID = adb.PAGE_VIEW_ID;
3.88
8
SELECT * FROM APEX_WORKSPACE_ACTIVITY_LOG
WHERE WORKSPACE = 'wks_name'
AND APEX_USER = 'user_name'
AND APPLICATION_ID = 'app_id';
SELECT * FROM APEX_DEBUG_MESSAGES;
Thank you!
8
3.88
(8 Votes)
0
Are there any code examples left?
New code examples in category SQL
