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;

Source: blogs.infomentum.com

Oracle apex view logs

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;

Source: blogs.infomentum.com

Similar codes

1 vote252 views1 answer
Mysql workbench in ubuntu 14.04
SQL
3 votes269 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
3 votes233 views2 answers
Oracle apex charging debug
SQL
3 votes239 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote237 views2 answers
Sql join on comma separated field
SQL
1 vote259 views1 answer
Write a query to create an empty table from an existing table?
SQL
3 votes219 views1 answer
System.debug apex
SQL
0 vote255 views1 answer
How to get one year old query from plan cache
SQL
-1 vote234 views1 answer
Mysql extract days
SQL
0 vote224 views1 answer
Mysql group by derived column
SQL