1Z0-771 practice question 15 of 15

You must use a Static Content region type to display messages about the employee of the month. Which text, when placed in this region, will display the message correctly?

Full set: 211 questions
Answer options
A: Join me in congratulating: P1_ENAME as the new employee of the month!
B: Join me in congratulating: &P1_ENAME. as the new employee of the month! Correct answer
C: Join me in congratulating V('P1_ENAME') as the new employee of the month!
D: Join me in congratulating & P1_ENAME. as the new employee of the month!
Correct Answer:
B. Join me in congratulating: &P1_ENAME. as the new employee of the month!
Explanation

In Oracle APEX, substitution strings are used to reference session state values of items within static content regions, labels, and other text-based components. The correct syntax for a substitution string is an ampersand (&) followed by the item name and terminated by a period (.). This syntax instructs the APEX engine to replace the placeholder with the current value of the specified page or application item during page rendering. The other options use incorrect syntax for this purpose.

Why Incorrect

A. This is plain text. The APEX engine will not substitute P1ENAME with its value without the correct substitution syntax.
C. V('P1ENAME') is the PL/SQL syntax for retrieving an item's value within a PL/SQL block, not for static content substitution.
D. The space between the ampersand (&) and the item name (P1ENAME) invalidates the substitution string syntax.

References

Oracle APEX Documentation, 23.2, "App Builder Concepts", Section 2.6 "Understanding Substitution Strings". This section explicitly states, "The syntax for a substitution string is &ITEMNAME. (including the trailing period)."

Oracle APEX Documentation, 23.2, "Developing Applications with Oracle APEX", Section 9.3.1.1 "About Static Substitution Strings". This section details the usage of &ITEM. syntax for referencing session state in static text.

Scroll to Top