Substitution Strings || Oracle APEX

Usage of Substitution Strings || Oracle APEX

Preview

You can use substitution strings in a page template or region source to replace a character string with another value. When you design your app and allow users to edit things, you use substitution strings to pass information.

OR

Use of substitution strings within templates, region source, or any attribute to pass information and replace a character string with another value.

Use static substitution strings for phrases or labels that occur in many places within an application. To create a substitution string, enter the string name in the Substitution String column and the string value in the Substitution Value column.

To create a substitution string, Go to the Edit Application Definition:

Preview

Substitution Syntax:

Reference Type Syntax
Bind variable :APP_NAME
PL/SQL V(‘APP_NAME’)
Substitution string &APP_NAME.
  1. Use of Bind variable:
declare
p_msg varchar2(100);
begin
select :S_MESSAGE into p_msg from dual;
apex_application.g_print_success_message := p_msg;
end;

Preview

  1. Use of PL/SQL:
begin
apex_application.g_print_success_message := V('S_MESSAGE');
end;

Preview

  1. Use of Substitution string in HTML, Region title name, Success Message, Item and button label name etc.

Preview


&S_MESSAGE.

Preview


comments powered by Disqus