Home » OrclApex » Oracle Apex: Using Server-Side Conditions

Oracle Apex: Using Server-Side Conditions

By

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.

Oracle Apex - server-side conditions.

  • 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: