You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for VARCHAR2


1 to 20 of 4070 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

VARCHAR2VIEW * WHENEVER *

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

Datatypes

VARCHAR2The VARCHAR2 datatype is a variable-length string of characters with a maximum length of 4000 bytes … format. If the VARCHAR2 string contains an illegal conversion character, Oracle returns an error and

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

CHAR versus VARCHAR2 Semantics

Assigning Character ValuesComparing Character Values Inserting Character Values

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

CHAR versus VARCHAR2 Semantics

B CHAR versus VARCHAR2 SemanticsThis appendix explains the semantic differences between the CHAR and VARCHAR2 base types. These

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

CHAR versus VARCHAR2 Semantics

Assigning Character ValuesWhen you assign a character value to a VARCHAR2 variable, if the value is shorter than the declared … declared length of the VARCHAR2 variable, PL/SQL aborts the assignment and raises VALUE_ERROR. PL/SQL

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

CHAR versus VARCHAR2 Semantics

Selecting Character Valuesthe assignment and raises VALUE_ERROR. When you select a column value into a VARCHAR2 variable, if … example, when you select a blank-padded CHAR column value into a VARCHAR2 variable, the trailing blanks … are not stripped. If the character value is longer than the declared length of the VARCHAR2 variable

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

CHAR versus VARCHAR2 Semantics

Comparing Character Valuesdeclarations last_name1 VARCHAR2(10):= 'COLES'; last_name2 VARCHAR2(10):= 'COLEMAN'; the following IF … VARCHAR2, non-blank-padding semantics are used. That is, when comparing character values of unequal … last_name1 VARCHAR2(10):= 'DOW'; last_name2 VARCHAR2(10):= 'DOW '; -- note trailing blanks the

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

CHAR versus VARCHAR2 Semantics

Inserting Character Valuescharacter value into a VARCHAR2 database column, Oracle does not strip trailing blanks. If the value is … RTRIM, which trims trailing blanks. An example follows: DECLARE... my_name VARCHAR2(15); BEGIN

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

Image Object Types Reference Information

VARCHAR2 (weightstring)A list of weights to apply to each visual attribute. Data type is VARCHAR2. The following

Concepts and Administration, 9i Release 2 (9.2.0.2)

Creating a Logical Standby Database

VARCHAR2 and VARCHARNVARCHAR2 NUMBER DATE

Concepts, 9i Release 2 (9.2.0.2)

Native Datatypes

VARCHAR2 and VARCHAR DatatypesThe VARCHAR2 datatype stores variable-length character strings. When you create a table with a … VARCHAR2 column, you specify a maximum string length (in bytes or characters) between 1 and 4000 bytes … for the VARCHAR2 column. For each row, Oracle stores each value in the column as a variable-length … VARCHAR2

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

Datatypes

LONG, RAW, LONG RAW, VARCHAR2You can use the piecewise capabilities provided by OCIBindByName(), OCIBindByPos(), OCIDefineByPos(), OCIStmtGetPieceInfo() and OCIStmtSetPieceInfo() to perform inserts, updates or fetches involving column data of these types.

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

Modeling and Design

UNICODE Support for VARCHAR2 and CLOBIn this release, database UNICODE support for VARCHAR2s [unicode] provides a few UNICODE variants on functions INSTR, SUBSTR, LENGTH, and LIKE. These UNICODE functions are not yet supported on CLOBs or NCLOBs as summarized in TableĀ 7-7. See Also: Oracle9i Supplied PL/SQL Packages and Types Reference Oracle9i Application Developer's Guide - Fundamentals Oracle9i SQL Reference Oracle9i Database Globalization

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

SDO_INDEX_NAME VARCHAR2 Name of the index.

SDO_INDEX_NAME VARCHAR2 Name of the index.SDO_INDEX_TYPE VARCHAR2 Contains QTREE (for a quadtree index) or RTREE (for an R-tree index). SDO_INDEX_NAME VARCHAR2 Name of the index.

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

Modeling and Design

Accepting CLOBs in VARCHAR2 Operators/FunctionsSQL operators/functions that currently take VARCHAR2 columns as operands or arguments are now

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

Modeling and Design

Implicit Conversions Between CLOB and VARCHAR2The implicit conversion in both directions, from CLOB to VARCHAR2, and from VARCHAR2 to CLOB, have … into VARCHAR2 PL/SQL variables VARCHAR2 columns can be selected into CLOB variables Assignment and parameter passing between CLOBs and VARCHAR2s

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

Modeling and Design

VARCHAR2 and CLOB in PL/SQL Built-in FunctionsCLOB and VARCHAR2 are still two distinct types. But depending on the usage, a CLOB can be passed to … SQL and PL/SQL VARCHAR2 built-in functions, behaving exactly like a VARCHAR2. Or the variable can … , "PL/SQL Example 4: CLOB Variables in PL/SQL". PL/SQL VARCHAR2 functions/operators need to take CLOBs … as argument

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

Migrating From LONGs to LOBs

VARCHAR2 and CLOB in PL/SQL Built-In FunctionsPL/SQL VARCHAR2 functions and operators take CLOBs as arguments or operands. A CLOB can be passed … to SQL and PL/SQL VARCHAR2 built-in functions, behaving exactly like a VARCHAR2. Or the VARCHAR2 … operators (>, =, <,!=) If a function returns a CLOB and the result is assigned to a VARCHAR2 variable

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

Modeling and Design

How SQL VARCHAR2/RAW Semantics Apply to CLOBs/BLOBswithout using any special LOB API. In PL/SQL, you can define a VARCHAR2 for a CLOB and RAW for a BLOB … column. You can also define CLOBs/BLOBs for VARCHAR2/RAW columns. Selecting a CLOB Column into a CHAR … Buffer or CLOB In PL/SQL, if a CLOB column is selected into a local VARCHAR2 variable, data stored … the SELECT, the VARCHAR2

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

PL/SQL Collections and Records

How Globalization Settings Affect VARCHAR2 Keys for Associative Arraysarrays with VARCHAR2 key values, the program might encounter a runtime error. For example, changing … must use a VARCHAR2, STRING, or LONG type. You can use a different type, such as NCHAR or NVARCHAR2, as … it can be converted to VARCHAR2 by the TO_CHAR function. However, you must be careful when using … same VARCHAR2