Check inside your APEX application if debug mode is enabled

Sounds like a simple task but whenever I have the requirement to add a region and make it conditional to check if APEX is running in debug mode, I always search for half an hour finding the right solution.

Search example on Google: “Oracle APEX check debug mode conditional PL/SQL”. Trying this or 30 different other ways it always ends up with the wrong results.

But it is so easy. Conditional PL/SQL Expression:

APEX_APPLICATION.G_DEBUG

G_DEBUG returns true or false! The documentation is a bit imprecise because it says “Yes” or “No”.

Anyway it is all well documented in the APEX documentation under APEX_APPLICATION > Global Variables: https://docs.oracle.com/database/apex-18.1/AEAPI/Global-Variables.htm#AEAPI29544