Results for UPPER


1 to 60 of 333 results. Prev  Next
Results per page:  20 | 40 |  60 


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 160 of 177

UPPERSyntax upper::= Text description of upper Purpose UPPER returns char, with all letters uppercase … UPPER('Large') \"Uppercase\" FROM DUAL; Upper ----- LARGE

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Working with Labeled Data

Determining Upper and Lower Bounds of LabelsThis section describes the Oracle Label Security functions which determine the least upper bound or … returned by a query; they return one result for each row. Finding Least Upper Bound with LEAST_UBOUND … labels must all belong to the same policy. Finding Least Upper Bound with LEAST_UBOUND The … LEAST_UBOUND (LUBD) function

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Administering and Using Trusted Stored Program Units

Returning Greatest Lower Bound and Least Upper Bound; LEAST_UBOUND This function returns an Oracle Label Security label that is the least upper bound of the … Also: \"Determining Upper and Lower Bounds of Labels\". The functions above are the same as those

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0746 command_option option out of range ( lower through upper )Cause: The specified value was not in the range. Action: Specify a value in the range.

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 7 of 134

ReturnsThe upper bound of the given collection.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-10834 upper-case form of section name string too longCause: Upper-case form of the section name is longer then supported length. Action: Reduce length of section name when adding section.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12400 to ORA-12699

ORA-12476 least upper bound resulted in an invalid OS labelCause: You tried to do an operation that generated a least upper bound (LUB) label which is not a

Spatial User's Guide and Reference, 9i Release 2 (9.2.0.2)

1003 or 2003 3 Rectangle type sometimes called optimized rectangle. A bounding rectangle such that only…

1003 or 2003 3 Rectangle type sometimes called optimized rectangle. A bounding rectangle such that only…rectangle ). A bounding rectangle such that only two points, the lower-left and the upper-right, are

SNMP Support Reference Guide, 9i Release 2 (9.2.0.2)

Interpreting Variables of the Oracle Database MIB

Typical RangeCan wrap around the upper limit of 2147483647 in about three days of continuous instance operation for a busy database

Administrator's Guide, 9i Release 2 (9.2.0.2)

Synchronization with Oracle Human Resources

Configuring a SQL SELECT Statement in the Configuration File to Support Complex Selection Criteria(ppx.email_address),'@ORACLE.COM',''), EMAILADDRESS, UPPER(ppx.attribute26) GUID, UPPER(ppx.last_name) LASTNAME … , UPPER(ppx.first_name) FIRSTNAME, UPPER(ppx.middle_names) MIDDLENAME, UPPER(ppx.known_as) NICKNAME … , UPPER(SUBSTR(ppx.date_of_birth,1,6)) BIRTHDAY, UPPER(ppx.employee_number)

interMedia User's Guide and Reference, 9i Release 2 (9.2.0.2)

Exceptions and Error Messages

IMG-00505, \"missing value in CUT rectangle\"integer values for the lower-left and upper-right vertices.

interMedia User's Guide and Reference, 9i Release 2 (9.2.0.2)

Exceptions and Error Messages

IMG-00506, \"extra value in CUT rectangle\"integer values for the lower-left and upper-right vertices.

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 7 of 134

CommentsReturns the maximum number of elements that the given collection can hold. A value of zero indicates that the collection has no upper bound.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_XMLQUERY, 4 of 4

Syntax(IN) Context handle. tCase (IN) The tag's case; 0=asAre, 1=lower, 2=upper.

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Navigational and Type Functions, 35 of 36

type_name (IN)Name of the type to get. This string must be all in upper-case, or else OCI throws an internal error and the program stops.

Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.xml.sql.query

useUpperCaseTagNames()Description Sets all tag names to upper case. This call should be made only after all the desired

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Releasability Using Inverse Groups

LEAST_UBOUND with Inverse GroupsThe LEAST_UBOUND (LUBD) function returns a character string label that is the least upper bound of … upper bound is the highest level, the union of the compartments in the labels, and t he union of the … groups in the labels. With inverse groups, the least upper bound is the highest level, the union of the … , with inverse groups

Reference, 9i Release 2 (9.2.0.2)

CTX_QUERY Package

exactSpecify TRUE for an exact count. Specify FALSE for an upper-bound estimate. Specifying FALSE returns a less accurate number but runs faster.

Application Developer's Guide - Advanced Queuing, 9i Release 2 (9.2.0.2)

Managing AQ

Restrictions on Queue Management: Queue names and queue table names are converted to upper case. Mixed case (upper and lower case

Recovery Manager Reference, 9i Release 2 (9.2.0.2)

RMAN Commands, 57 of 59

PurposeA subclause that specifies an upper limit by time, SCN, or log sequence number for various RMAN

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Navigational and Type Functions, 35 of 36

schema_name (IN, optional)must be all in upper-case, or else OCI throws an internal error and the program stops.

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Understanding Indexes and Clusters

Using Function-based IndexesUPPER 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

XML API Reference - XDK and Oracle XML DB, 9i Release 2 (9.2.0.2)

XML SQL Utility (XSU) for PL/SQL

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.

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

TREATTRIM UPPER Character Functions Returning Number Values Character functions that return number

Precompilers, 9i Release 2 (9.2.0.2)

Info

Conventions Used in This GuideImportant terms being defined for the first time are italicized. In discussions, UPPER CASE is used

Pro*Fortran, 9i Release 2 (9.2.0.2)

Writing a Pro*FORTRAN Program

Declaring Host Arraysarrays are declared, each with an upper dimension bound of 50 (the lower bound defaults to 1):

Workflow Guide (Oracle Workflow Help), 9i Release 2 (9.2.0.2)

\"To View the Details of a Notification (Oracle Workflow Help)

To View the Details of a Notification1. In the Detail Notification page, the full details of the notification appear in the upper frame

Globalization Support Guide, 9i Release 2 (9.2.0.2)

OCI Programming in a Global Environment

flag(IN)Specify the case to which to convert: OCI_NLS_UPPERCASE: Convert to upper case OCI_NLS_LOWERCASE

Globalization Support Guide, 9i Release 2 (9.2.0.2)

OCI Programming in a Global Environment

flag(IN)Specify the case to convert: OCI_NLS_UPPERCASE: Convert to upper case OCI_NLS_LOWERCASE: Convert

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Precompiler Concepts

Case-InsensitivityCOBOL statements are case-insensitive. The precompiler accepts both upper- and lower-case tokens.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

Character Setof 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.

Recovery Manager Reference, 9i Release 2 (9.2.0.2)

RMAN Commands, 57 of 59

Keywords and ParametersSyntax 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

SQL Reference, 9i Release 2 (9.2.0.2)

Conditions, 3 of 13

Group Comparison Conditionsdescription 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

Objects for OLE, 9i Release 2 (9.2.0.2)

SetXMLUpperCase (ODynaset) Method

SetXMLUpperCase (ODynaset) Methodmethods 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

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

User Exits

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.

Precompilers, 9i Release 2 (9.2.0.2)

Writing User Exits

Connecting to OracleSQL*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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Linguistic Sorting

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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 26 of 52

Examples, deptno) VALUES (4160, 'STURDEVIN', 'SECURITY GUARD', 2045, NULL, 30);... INSERT INTO dept VALUES (my_deptno, UPPER(my_dname), 'CHICAGO');

Programmer's Guide, 9i Release 2 (9.2.0.2)

Object-Relational Datatypes

Collection Data Manipulation Functionsto another OCICollGetElem() get pointer to an element given its index OCICollMax() get upper bound

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Running the Pro*PL/I Precompiler

Case Sensitivity, including the name of the Pro*PL/I executable, using the correct combination of upper and lowercase letters.

Reference, 9i Release 2 (9.2.0.2)

CTX_QUERY Package

COUNT_HITSmode. Exact mode returns the exact number of hits for the query. Estimate mode returns an upper-bound estimate but runs faster than exact mode.

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL Statements and Directives

COLLECTION APPEND (Executable Embedded SQL Extension)cannot append to a NULL collection, or append beyond the upper bound of a collection. Syntax Text

interMedia Java Classes User's Guide and Reference, 9i Release 2 (9.2.0.2)

JAI Input and Output Stream Reference Information

bThe byte to be written to the BLOB. Only the low-order byte is written; the upper 24 bits are

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Command Reference

SET SQLC[ASE] { MIX[ED ]|LO[WER]|UP[PER]}UPPER, to lowercase if SQLCASE equals LOWER, and makes no changes if SQLCASE equals MIXED. SQLCASE does not change the SQL buffer itself.

SNMP Support Reference Guide, 9i Release 2 (9.2.0.2)

Interpreting Variables of the Oracle Database MIB

Explanationtypically contains 200 datafiles in a tablespace. The upper limit is hard coded as 1023.

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Writing a Pro*PL/I Program

Host Variable Namesconverts variable names to upper case. Check your compiler documentation for the rules for forming PL/I identifiers on your system.

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Modeling and Design

SQL and PL/SQL VARCHAR2 Functions/Operators Now Allowed for CLOBs() and RTRIM() LOWER(), UPPER(), NLS_LOWER(), NLS_UPPER() LPAD() and RPAD()

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 3 of 134

Commentserror is returned if the upper-bound of the lhs collection is less than the current number of … is a type mismatch between the lhs and rhs collections the upper bound of lhs collection is less than the current number of elements in the rhs collection

Sample Schemas, 9i Release 2 (9.2.0.2)

Oracle9i Sample Schema Scripts

oe_idx.sqlINDEX prod_supplier_ix ON product_information (supplier_id); CREATE INDEX cust_upper_name_ix ON customers (UPPER(cust_last_name), UPPER(cust_first_name));

Objects for OLE, 9i Release 2 (9.2.0.2)

Find_Click() Event Procedure

Find_Click() Event Procedureupper case FindClause = \"UPPER(ename) = \" & SingleQuote & UCase(txtEname) & SingleQuote

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Understanding Varraysextensible upper bound. For example, the current upper bound for varray Grades is 7, but you can extend it to

Globalization Support Guide, 9i Release 2 (9.2.0.2)

OCI Programming in a Global Environment

OCIMultiByteStrCaseConversion(), ub4 flag) Purpose This function converts the multibyte string pointed to by srcstr into upper case or

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Handling Runtime Errors

Declaring SQLSTATEmust be declared inside the Declare Section. You declare SQLSTATE as char SQLSTATE[6]; /* Upper case is

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Overview of Globalization Support

Linguistic Sortingupper case or lower case using the basic definition always retain their lengths. Strings converted

SNMP Support Reference Guide, 9i Release 2 (9.2.0.2)

Interpreting Variables of the Oracle Database MIB

Explanationhard file limit of 1023 database files exists, so this number is the practical upper limit. Although

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SQL, 2 of 2

Parametersrange. index2 Index for the table element that marks the upper bound of the range.

SQL*Module for Ada Programmer's Guide, 9i Release 2 (9.2.0.2)

Running SQL*Module

Case Sensitivity in Program Names, Option Names, and Valuesoption value is a filename, and your operating system is case-sensitive, you must enter the filename using the correct combination of upper and lowercase

Enterprise Manager Getting Started with the Oracle Standard Management Pack, 9i Release 2 (9.2.0.2)

Using Oracle TopSessions

Using the Chart Status ButtonUse the Chart Status button in the upper right corner of the TopSessions chart to access many of

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Oracle Database Event Tests

Parametersuser name is case sensitive. By default the user name is all upper case. To define a name in lower

Enterprise Manager Getting Started with the Oracle Diagnostics Pack, 9i Release 2 (9.2.0.2)

Using Oracle TopSessions

Using the Chart Status ButtonUse the Chart Status button in the upper right corner of the TopSessions chart to access many of





Was this page helpful?

Integrated Cloud Applications & Platform Services