Oracle apex charging debug

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 charging debug

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

0 vote160 views1 answer
Mysql into outfile with headers
SQL
3 votes209 views2 answers
Oracle privileges users
SQL
0 vote147 views1 answer
Update table sql multiple set
SQL
0 vote134 views1 answer
Add plugins to mysql workbench
SQL
0 vote151 views1 answer
Oracle INTERVAL DAY to second to number
SQL
16 votes138 views2 answers
Add column to all tables after first column mysql
SQL
0 vote155 views1 answer
Select multiple row from primary key sql
SQL
2 votes133 views2 answers
Change varchar length mysql
SQL
0 vote134 views1 answer
Is numeric in sql
SQL
14 votes144 views3 answers
Alter foreign key
SQL