schema_name (IN, optional) → must be all in upper-case, or else OCI throws an internal error and the program stops.
setTagCase() → ctxType, tCase IN NUMBER); Parameter IN / OUT Description ctxHdl (IN) Context handle. tCase (IN) The tag's case; 0=asAre, 1=lower, 2=upper.
TREAT → TRIM UPPER Character Functions Returning Number Values Character functions that return number
Using Function-based Indexes → UPPER function, or included in an expression, such as col1 + col2. Defining a function-based index on … expressions, in a WHERE or ORDER BY clause. Function-based indexes defined with the UPPER … index: CREATE INDEX uppercase_idx ON employees (UPPER(last_name)); facilitates processing queries … such as: SELECT * FROM employees
Conventions Used in This Guide → Important terms being defined for the first time are italicized. In discussions, UPPER CASE is used
Declaring Host Arrays → arrays are declared, each with an upper dimension bound of 50 (the lower bound defaults to 1):
To View the Details of a Notification → 1. In the Detail Notification page, the full details of the notification appear in the upper frame
flag(IN) → Specify the case to which to convert: OCI_NLS_UPPERCASE: Convert to upper case OCI_NLS_LOWERCASE
flag(IN) → Specify the case to convert: OCI_NLS_UPPERCASE: Convert to upper case OCI_NLS_LOWERCASE: Convert
Case-Insensitivity → COBOL statements are case-insensitive. The precompiler accepts both upper- and lower-case tokens.
Character Set → of characters. The PL/SQL character set includes the upper- and lower-case letters A.. Z and a.. z … corresponding upper-case letters except within string and character literals.
Keywords and Parameters → Syntax Element Description UNTIL TIME = ' date_string ' Specifies a time as an upper limit. RMAN … week ago. UNTIL SCN = integer Specifies an SCN as an upper limit. RMAN selects only files that can … THREAD = integer Specifies a redo log sequence number and thread as an upper limit. RMAN selects only
Group Comparison Conditions → description of expression_list If you use the upper form of this condition (with a single … expression to the left of the operator), then you must use the upper form of expression_list. If you use the
SetXMLUpperCase (ODynaset) Method → methods are called. Usage void SetXMLUpperCase (bool upper) const throw( OException ) Remarks The … upper case. This method should be called only AFTER all custom tag or attribute names have been set by
Naming the Exit → *Forms converts the name of a user exit to upper case before searching for the exit. Therefore, the exit name must be in upper case in your source code.
Connecting to Oracle → SQL*Forms converts the name of a user exit to upper case before searching for the exit. Therefore … , the exit name must be in upper case in your source code if your host language is case-sensitive. The
Special Uppercase Letters → … The UPPER, LOWER, and INITCAP SQL functions cannot handle these special characters. The NLS_UPPER … : SELECT NLS_UPPER ('große') \"Uppercase\" FROM DUAL; Upper ----- GROSSE See Also: Oracle9i SQL Reference
Examples → , deptno) VALUES (4160, 'STURDEVIN', 'SECURITY GUARD', 2045, NULL, 30);... INSERT INTO dept VALUES (my_deptno, UPPER(my_dname), 'CHICAGO');
Collection Data Manipulation Functions → to another OCICollGetElem() get pointer to an element given its index OCICollMax() get upper bound