4.2 Global Variables

Global Variable Description
G_USER Specifies the currently logged in user.
G_FLOW_ID Specifies the ID of the currently running application.
G_FLOW_STEP_ID Specifies the ID of the currently running page.

Defaults to the application's parsing schema. Use #OWNER# to reference this value in SQL queries and PL/SQL.


Changing G_FLOW_OWNER at runtime does not change the parsing schema.

G_REQUEST Specifies the value of the request variable most recently passed to or set within the show or accept modules.
G_BROWSER_LANGUAGE Refers to the web browser's current language preference.
G_DEBUG Refers to whether debugging is switched on or off. Valid values for the DEBUG flag are Yes or No. Enabling debug shows details about application processing.
G_HOME_LINK Refers to the home page of an application. If no page is given and if no alternative page is dictated by the authentication scheme's logic, the Oracle APEX engine redirects to this location.
G_LOGIN_URL Used to display a link to a login page for users that are not currently logged in.
G_IMAGE_PREFIX Refers to the virtual path the web server uses to point to the images directory distributed with APEX.
G_FLOW_SCHEMA_OWNER Refers to the owner of the APEX schema.
G_PRINTER_FRIENDLY Refers to whether the APEX engine is running in print view mode. This setting can be referenced in conditions to eliminate elements not desired in a printed document from a page.
G_PROXY_SERVER Refers to the application attribute Proxy Server.
G_SYSDATE Refers to the current date on the database server. G_SYSDATE uses the DATE datatype.
G_PUBLIC_USER Refers to the Oracle schema used to connect to the database through the database access descriptor (DAD).
G_GLOBAL_NOTIFICATION Specifies the application's global notification attribute.
G_X01, ... G_X10 Specifies the values of the X01, ... X10 variables most recently passed to or set within the show or accept modules. You typically use these variables in On-Demand AJAX processes.