Determines whether the operator can perform case-insensitive queries on the text item.
Applies to text item
Set Oracle Forms, programmatically
Default
No
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.
If you set this property to Yes, queries may take longer to execute.