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

2 votes308 views4 answers
List databases in sql server
SQL
1 vote316 views1 answer
Postgresql export output table as a csv
SQL
0 vote276 views2 answers
Sql update from two different database
SQL
0 vote306 views2 answers
Postgres another version
SQL
0 vote316 views2 answers
Suse stop MySQL
SQL
-2 votes296 views1 answer
Modify column name in tsql
SQL
13 votes279 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote304 views1 answer
Sql trying to delete database in use
SQL
2 votes346 views1 answer
Oracle run_duration to number
SQL
1 vote299 views1 answer
Install postgresql on raspberry pi
SQL