APEX built-in variables

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

For all you guys ‘n dolls here an overview of the built-in apex variables and how/when to use ’em:

  • APP_ALIAS
  • APP_ID
  • APP_IMAGES
  • APP_PAGE_ID
  • APP_SESSION
  • APP_UNIQUE_PAGE_ID
  • APP_USER
  • AUTHENTICATED_URL_PREFIX
  • BROWSER_LANGUAGE
  • CURRENT_PARENT_TAB_TEXT
  • DEBUG
  • HOME_LINK
  • LOGIN_URL
  • IMAGE_PREFIX
  • Application Express SCHEMA OWNER
  • PRINTER_FRIENDLY
  • LOGOUT_URL
  • PROXY_SERVER
  • PUBLIC_URL_PREFIX
  • REQUEST
  • SQLERRM
  • SYSDATE_YYYYMMDD
  • WORKSPACE_IMAGES

taken from this source

Variables can be referred to in three ways:

  • Bind variable ( :APP_ID )
    Used inside APEX in SQL and PL/SQL
  • V and NV functions ( NV(‘APP_ID’) )
    Used outside APEX ( in PL/SQL packages for example )
  • Substitution strings ( &APP_ID. )
    Used inside APEX in items for example

 

One thought on “APEX built-in variables”

Leave a Reply