In Oracle Apex, server-side conditions execute at the time of page initialization. You can use the server-side condition for objects such as items, regions, buttons, processes and for dynamic actions. If you have used applied a server-side condition, then the object will not appear if the condition does not evaluate to true.
Here I am giving the details of the most used types of server-side conditions available in Oracle Apex.
Server-Side Conditions in Oracle Apex
- Rows returned: You need to specify an SQL query if you choose this option. And the object will be processed or rendered only if the query will return at least one row.
- No Rows returned: The object will be processed if the SQL returns no rows.
- SQL Expression: The SQL expression evaluates to TRUE.
- PL/SQL Expression: The PL/SQL expression evaluates to TRUE. For example,
Substr(:P2_ACCOUNT_TYPE, 1, 2) = 'DR'
. - PL/SQL Function Body: The PL/SQL function body returns TRUE. For example:
Begin If :P3_STATUS = 'A' then Return True; else Return False; End if; End;
- Request = Value: The page request is equal to the text you enter into the Value attribute.
- Request != Value: The page request is not equal to the text you enter into the Value attribute.
- The request is contained in Value: The page request is contained in the text you enter into the Value attribute. Mostly we use this condition for buttons and specify the button names in the Value attribute.
- The request is NOT contained in Value: The page request is not contained in the text you enter into the Value attribute.
- Item = Value: The value of the selected Item is equal to the text you enter into the Value attribute.
- Item != Value: The value of the selected Item is not equal to the text you enter into the Value attribute.
- Item is NULL: The value of the selected Item is empty.
- Item is NOT NULL: The value of the selected Item is not empty.
- Item is zero: The value of the selected Item is the number zero.
- Item is NOT zero: The value of the selected item is not the number zero.
- Item is NULL or zero: The value of the selected Item is empty or the number zero.
- Item is NOT NULL and NOT zero: The value of the selected Item is not empty and not the number zero.
- Item contains no spaces: The value of the selected Item has no spaces.
- Item is numeric: The value of the selected Item is numeric.
- Item is NOT numeric: The value of the selected Item is not numeric.
- Item is alphanumeric: The value of the selected Item is alphanumeric, containing only letters or numbers and no special characters.
- Item is in the colon-delimited list: The value of the selected Item is completely contained in the text you enter into the Value attribute. Specify the value separated by colons (:). For example ABC:XYZ.
- Item is NOT in the colon-delimited list: The value of the selected Item is not completely contained in the text you entered into the Value attribute.
Related Tutorials:
- Oracle Apex: Set Value Dynamic Action Examples
- Oracle Apex: Display Custom Error Messages from PL/SQL Process