A script-enabled browser is required for this page to function properly.

Case Insensitive Query Property

Description

Determines whether the operator can perform case-insensitive queries on the text item.

Applies to text item

Set Oracle Forms, programmatically

Refer to Built-in

GET_ITEM_PROPERTY

SET_ITEM_PROPERTY

Default

No

Usage Notes

Case-insensitive queries are optimized to take advantage of an index. For example, assume you perform the following steps:

Oracle Forms constructs the following statement:

SELECT * FROM EMP WHERE UPPER(ENAME) = 'BLAKE' AND
(ENAME LIKE 'Bl%' OR ENAME LIKE 'bL%' OR
ENAME LIKE 'BL%' OR ENAME LIKE 'bl%');

The last part of the WHERE clause is performed first, making use of the index. Once the database finds an entry that begins with bl, it checks the UPPER(ENAME) = 'BLAKE' part of the statement, and makes the exact match.

Case Insensitive Query Restrictions

If you set this property to Yes, queries may take longer to execute.


About defining items for Enter Query mode