Skip to Main Content
PLUG-INS
Long report into columns
Resizing dialog
Copy to clipboard
Time Touch Input
Restrict Shuttle
Copy Down
Store location
GENERATORS
Pipelined Function Generator
Generate substitution code
Generate getter and setter
Rewrite Query Parameters
Log statement
Align text on characters
Format APEX region source query
Format query
APEX EXAMPLES
Apex 5.0 Icons
Apex 5.1 Font Icons
Disabling items in tabular form
Usage Map
Excel Export
Introduction
This page performs the conversion of different types of query parameters. Paste your, fill in the parameters and hit Generate. For more information see
this blogpost
Rewrite query variables
Code
From
bind variables
PL/SQL variables
substitution parameters
Apex v-function call
To
bind variables
PL/SQL variables
substitution parameters
Apex v-function call
Substitution delimiters
PL/SQL variable prefix
Apex prefix
Case
lower case
UPPER CASE
Generate
Result
Code
Copy to Clipboard