Oracle Apex - Substitution String

Card Puncher Data Processing


You can use substitution strings within:

  • a page template
  • or region source

to replace a character string with another value.


See Built-in Substitution Strings documentation



In the application properties, you can set the “Exact Substitution” parameter.

  • Exact substitutions use the following syntax:
  • Non-exact substitutions use the syntax:

Documentation / Reference

Discover More
Apex Substitution Variable
Oracle Apex - (Variable|State Value|Flag)

Variable in Apex. substitution string where: #VARIABLE# is a substitution string in Page template &VARIABLE. is a substitution string :VARIABLE is a bind variable V is a shorthand function...
Oracle Apex Report Columns Metadata
Oracle Apex - Metadata

The metadata of Oracle Apex are stored in a schema prefixed with APEX. From this schema, you can query the whole application definition: from page to columns APEX_APPLICATION_ALL_AUTH APEX_APPLICATION_AUTH...

Share this page:
Follow us:
Task Runner