A Available Conditions

For example, to check if the current language is either en-US or en-UK, choose this condition and enter the following string in Expression 1:

en-us,en-uk

1,2,3,4

See Also: "Using f?p Syntax to Link Pages" for more information on f?p syntax

select 1 from emp where deptno = :P101_DEPTNO

This example references item P101_DEPTNO as a bind variable. You can use bind variables a within an application processes and SQL query regions to reference item session state. If one or more employees are in the department identified by the value of P101_DEPTNO then the condition evaluates as true.

See Also: "About Bind Variables" for more information on bind variables

nvl(:MY_FLOW_ITEM,'NO') = 'YES'

If the value of MY_FLOW_ITEM is YES then the condition evaluates as true. Otherwise it evaluates as false.

BEGIN
IF :P1_DAY = 'MONDAY' THEN
    RETURN TRUE;
ELSE
    RETURN FALSE;
END;

For example, the event could be when a user clicks a button or selects a tab menu. Depending upon the event, you can perform different operations by referencing the value of the REQUEST application attribute.

This condition evaluates as true if REQUEST does not equal the value entered in Expression 1.

See Also: "Understanding URL Syntax", "REQUEST ", and "Understanding the Relationship Between Button Names and REQUEST"

This condition evaluates as true if REQUEST equals the value entered in Expression 1. From PL/SQL you can also reference the application attribute using the following syntax:

v('REQUEST')

See Also: "Understanding URL Syntax", "REQUEST ", and "Understanding the Relationship Between Button Names and REQUEST"

Use this condition to specify a list of allowed requests (such as SAVE or UPDATE) in Expression 1. The condition evaluates to true if the value of REQUEST is contained in the list.

See Also: "REQUEST ", and "Understanding the Relationship Between Button Names and REQUEST"

See Also: "REQUEST ", and "Understanding the Relationship Between Button Names and REQUEST"

The HTML DB engine processes the following:

select 1 from dual where :MY_ITEM = 'ABC'

This condition evaluates to true if a row is returned.

See Also: "Using Substitution Strings" for more information on &MY_ITEM syntax

To check if the item F100_P2_DAY_DATE equals "Wednesday", select this condition enter the following in Expression 1 and Expression 2:

• Expression 1: F100_P2_DAY_DATE

• Expression 2: Wednesday

See Also: "Using Substitution Strings" for more information on &MY_ITEM syntax

See Also: "Providing Security Through Authorization" for more information on authentication

A public user is a user used for multiple users. Sometimes applications have pages that are public and thus require authentication and log in. This condition returns true if the user is the public user (that is, the user is authenticated as themselves or some other user not equal to the public user identified in the application attribute Public User.

See Also: "About Session Management"

For example, to verify whether the value of an item F100_P2_WORD is contained within the string "the quick brown fox", enter the following in the Expression 1 and Expression 2 fields:

• Expression 1: F100_P2_WORD

• Expression 2: the quick brown fox

To check if the item F100_P1_TODAY is either "Monday", "Tuesday", or "Wednesday", select this condition and enter the following in Expression 1 and Expression 2:

• Expression 1: P1_TODAY

• Expression 2: Monday: Tuesday:Wednesday

Checks for the DAD (Database Access Descriptor) that is being used in the URL to call the current page in the application and compares it to Expression 1. Evaluate to true, when the DAD is not the same as Expression 1.

Checks for the value of the CGI environment variable HTTP_HOST that is the value returned by owa_util.get_cgi_env ('HTTP_HOST'). Evaluate to true, when this value is not equal to the string in Expression 1.

This condition checks for the value of the CGI environment variable SERVER_NAME, that is the value returned by owa_util.get_cgi_env ('SERVER_NAME'). Evaluate to true, when this value is not equal to the string in Expression 1.