Oracle Apex: Using Server-Side Conditions

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