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 vote289 views1 answer
Select first rows postgresql
SQL
14 votes286 views4 answers
Remove record from table sql
SQL
2 votes278 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote265 views1 answer
Concat column value of same user in mysql
SQL
0 vote271 views1 answer
PSQL qith variables
SQL
0 vote268 views1 answer
Mysql date minus 1 day
SQL
0 vote282 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
5 votes273 views1 answer
Purge undo tablespace oracle 11g
SQL
2 votes265 views2 answers
Postgresql date at timezone
SQL
2 votes292 views1 answer
How to find table table in stored procedure sql server
SQL