APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn

 

Tips & Tricks

Print
12
Apr

APEX built-in variables

Written by Richard Weug. Posted in Tips and Tricks

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

Here is 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

 

Original article: http://blog.warp11.nl/2011/04/apex-built-in-variables/