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

1 vote267 views1 answer
Create new table in SQL from old table with data
SQL
0 vote244 views1 answer
Sql server is not
SQL
-1 vote282 views1 answer
Default username and password for oracle 11g
SQL
3 votes284 views2 answers
Savepoint in sql
SQL
1 vote277 views1 answer
Delete from inner join sql
SQL
2 votes271 views1 answer
Oracle percentage
SQL
1 vote269 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote291 views1 answer
Command line mysql xampp
SQL
0 vote266 views1 answer
Running query in redshift
SQL
0 vote244 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL