Previous Next JavaScript must be enabled to correctly display this content

## E Available Conditions

Learn about conditions available in App Builder.

- What Are Conditions?
  Learn about conditions.
- Conditions Available in App Builder
  Review descriptions of conditions available in Oracle APEX.

Related Topics

- Understanding Conditional Rendering and Processing

### E.1 What Are Conditions?

Learn about conditions.

A condition is a small unit of logic that helps developers control the display of regions, items, buttons, and tabs as well execute processes, computations and validations. When you apply a condition to a control or component, the condition is evaluated. Whether a condition passes or fails determines whether a control or component displays, or page processing executes.

You can specify conditions by selecting a condition type when you create the control (region, button, or item) or component (tab, list, or navigation bar), or by making a selection under the condition attribute.

Parent topic: Available Conditions

### E.2 Conditions Available in App Builder

Review descriptions of conditions available in Oracle APEX.

Tip:

To view a complete listing of all available conditions for a given control or component, expand the condition type list.

Condition | Description
--- | ---
Rows returned | The SQL query returns one or more rows.
No Rows returned | The SQL Query returns no rows
SQL Expression | The SQL expression evaluates to TRUE.
PLSQL Expression | The SQL expression evaluates to TRUE.
PL/SQL Function Body | The PL/SQL function body returns TRUE.
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.
Request is contained in Value | The page request is contained in the text you enter into the Value attribute.
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 colon delimited list | The value of the selected item is completely contained in the text you enter into the Value attribute.
Item is NOT in colon delimited list | The value of the selected Item is not completely contained in the text you entered into the Value attribute.
User Preference = Value | The value of the Preference entered is equal to the text you enter into the Value attribute.
User Preference != Value | The value of the Preference entered is not equal to the text you enter into the Value attribute.
Current Page = Page | The current page is equal to the value you enter into Page.
Current Page != Page | The current page is not equal to the value you enter into Page.
Current Page is in comma delimited list | The current page is in the comma separated list you enter into Pages.
Current Page is NOT in comma delimited list | The current page is not in the comma separated list you enter into Pages.
Current page is in Printer Friendly mode | The current page has been toggled to 'Printer Friendly Mode' by the end user.
Current page is NOT in Printer Friendly mode | The current page has not been toggled to 'Printer Friendly Mode' by the end user.
Page/Region is Read Only | Either the page or parent region, if appropriate, 'Read Only' condition evaluates to TRUE.
Page/Region is NOT Read Only | The page and parent region, if appropriate, are displayed normally.
User is authenticated (not public) | The end user is logged into the application. See Also: Establishing User Identity Through Authentication for information about authentication
User is the public user (user has not authenticated) | The end user is not logged into the application.
Inline Validation Errors Displayed | An inline validation error is displayed on the page, following a page submission.
Inline Validation Errors NOT displayed | An inline validation error is not displayed on the page.
Current Language = Value | The end user is currently running the application in the language you enter into the Value attribute.
Current Language != Value | The end user is not currently running the application in the language you enter into the Value attribute.
Current Language is contained in Value | The end user is currently running the application in one of the languages you enter into the Value attribute.
Current Language is NOT contained in Value | The end user is not currently running the application in one of the languages you enter into the Value attribute.
Never | The component is never rendered. Note: Changing a condition to Never will remove any existing condition. For temporarily disabling a component, Oracle recommends using the Build Option attribute.

Parent topic: Available Conditions