APEX built-in variables

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

 

Leave a Comment