oracle apex view logs

Solutions on MaxInterview for oracle apex view logs by the best coders in the world

showing results for - "oracle apex view logs"
Lacy
15 Sep 2017
1SELECT adb.APEX_USER,
2       adb.APPLICATION_ID, wal.APPLICATION_NAME, adb.PAGE_ID,
3       adb.MESSAGE, adb.MESSAGE_TIMESTAMP,
4       adb.PAGE_VIEW_ID, adb.SESSION_ID
5FROM APEX_WORKSPACE_ACTIVITY_LOG wal
6INNER JOIN APEX_DEBUG_MESSAGES adb
7ON wal.DEBUG_PAGE_VIEW_ID = adb.PAGE_VIEW_ID;
Valerio
19 Oct 2016
1SELECT * FROM APEX_WORKSPACE_ACTIVITY_LOG 
2    WHERE WORKSPACE = 'wks_name'
3    AND APEX_USER = 'user_name'
4    AND APPLICATION_ID = 'app_id';
5    
6SELECT * FROM APEX_DEBUG_MESSAGES;