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 vote140 views1 answer
Php mysqli install
SQL
1 vote140 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
1 vote139 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote124 views1 answer
Oracle DROP PROGRAM
SQL
0 vote143 views1 answer
Sql select min
SQL
0 vote147 views1 answer
Modifier une valeur sql
SQL
34 votes131 views6 answers
Sql change data type
SQL
1 vote138 views1 answer
SQLite order random
SQL
17 votes183 views2 answers
How to assign date field for table in mysql
SQL
0 vote122 views1 answer
Knex last insert id mysql
SQL