Oracle Apex - (Variable|State Value|Flag)

Card Puncher Data Processing

About

Variable in Apex.

Often called in documentation substitution string

Syntax

#VARIABLE# -- In Page template 
&VARIABLE. -- In Apex form field (with the exact substitution parameter in application property)
&VARIABLE  -- In Apex form field (with the non-exact substitution parameter in application property)
:VARIABLE  -- In SQL and PLSQL
V('VARIABLE') -- PLSQL

where:

Type

  • Apex Collection. Collections enable you to temporarily capture one or more nonscalar values. You can use collections to store rows and columns currently in session state so they can be accessed, manipulated, or processed during a user's specific session.

Category

Built-In

Application Specific

  • Substition

Apex Substitution Variable

Session

Session state value. See Managing Session State Values

Global

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Apex - Debug (Messages)

The debug facility displays application processing details through messages that can be: enabled (to a certain information ) disabled added removed See constant...
Oracle Apex Items Type
Oracle Apex - (Form|Page) (Field|Item)

An item (also called a field) is a HTML form elements such as text fields, select lists, and check boxes. Every item has a session state value that can be referenced by a variable. Item names...
Card Puncher Data Processing
Oracle Apex - Application (flows)

An application is an HTML interface that exists on top of database objects such as tables or procedures In the URL, the application number is the first number in the parameter sequence, followed...
Card Puncher Data Processing
Oracle Apex - Application items

Application items are not associated with a page but with an application and therefore have no user interface properties. You can use an application item as a global variable. Shares session state...
Card Puncher Data Processing
Oracle Apex - Bind Variable

Bind variables syntax can be used for SQL or PL/SQL to reference session state of a specified item. Items Bind...
Oracle Apex Request Expression Condition
Oracle Apex - Request

The request is a system variable initialized: with the name of the button when a user clicks. or with the fourth parameter of the Apex URL It will then start the related process. You can...
Card Puncher Data Processing
Oracle Apex - Session (or application context)

A Session is created after : the authentication of a user the first visit of a public user with the zero session feature Each session is assigned a unique identifier. The Application Express...
Oracle Apex Session State Scope
Oracle Apex - Session state

Session state is a workspace that contains all variables with their values for one user. Session state can be maintained: Per session (to maintain session state per session). The session ID locate...
Oracle Apex Application Security Public User
Oracle Apex - User

A user in Apex. Once a user has been identified, the Application Express engine keeps track of each user by setting the value of the variable APP_USER. APP_USER...



Share this page:
Follow us:
Task Runner