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 4821 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Programmer's Guide, 10g Release 1 (10.1)

3 Datatypes

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

Release 1.8, 10g Release 1 (10.1)

Migrating to Oracle7

Using VARCHAR2 versus CHARVARCHAR2 versus CHAR The VARCHAR2 and CHAR datatypes differ in subtle but significant ways. CHAR … comparison belong to type VARCHAR2, non-blank-padding semantics are used. That is, when comparing character … is a CHAR column and job_title is a VARCHAR2 host variable, the following search condition is FALSE

Packages and Types Reference, 10g Release 1 (10.1)

173 JMS Types

get_text (payload OUT VARCHAR2)Puts the internal representation of the payload into a VARCHAR2 variable payload.

Concepts, 10g Release 1 (10.1)

26 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

Packages and Types Reference, 10g Release 1 (10.1)

173 JMS Types

get_text (payload OUT VARCHAR2)Puts the internal representation of the payload into a VARCHAR2 variable payload.

Concepts and Administration, 10g Release 1 (10.1)

4 Creating a Logical Standby Database

VARCHAR2 and VARCHARNVARCHAR2 NUMBER DATE

User's Guide and Reference, 10g Release 1 (10.1)

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

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

User's Guide and Reference, 10g Release 1 (10.1)

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

Comparing Character Valuesdeclarations last_name1 VARCHAR2(10):= 'COLES'; last_name2 VARCHAR2(10):= 'COLEMAN'; the following IF … true: IF last_name1 = last_name2 THEN... If either value in a comparison has datatype VARCHAR2, non … adjustments and uses the exact lengths. For example, given the declarations last_name1 VARCHAR2(10 … ):=

User's Guide and Reference, 10g Release 1 (10.1)

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

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, 10g Release 1 (10.1)

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

Assigning Character ValuesVARCHAR2 variable, if the value is shorter than the declared length of the variable, PL/SQL neither … information is lost. If the character value is longer than the declared length of the VARCHAR2 variable

User's Guide and Reference, 10g Release 1 (10.1)

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

B Understanding CHAR and VARCHAR2 Semantics in PL/SQLThis appendix explains the semantic differences between the CHAR and VARCHAR2 base types. These

Packages and Types Reference, 10g Release 1 (10.1)

173 JMS Types

set_string (id IN PLS_INTEGER, name IN VARCHAR2, value IN VARCHAR2)Sets the string value with the specified name in the map. Raises exception ORA-24197 if the Java stored procedure throws an exception during execution or ORA-24198 if the operation ID is invalid.

Programmer's Guide, 10g Release 1 (10.1)

3 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, 10g Release 1 (10.1)

10 PL/SQL Semantics for LOBs

CLOBs Follow the VARCHAR2 Collating Sequence, the result is consistent with if the CLOB data content is retrieved into a VARCHAR2 buffer and the … VARCHAR2 is compared. The rule applies to all cases including comparisons between CLOB and CLOB … , CLOB and VARCHAR2, and CLOB and CHAR. Note: When a CLOB is compared with a CHAR string, it is always

Packages and Types Reference, 10g Release 1 (10.1)

173 JMS Types

write_string (id IN PLS_INTEGER, value IN VARCHAR2)Writes a string to the stream message. Raises exceptions ORA-24196 if the stream message is in read-only mode, ORA-24197 if the Java stored procedure throws an exception during execution, or ORA-24198 if the operation ID is invalid.

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

10 PL/SQL Semantics for LOBs

Implicit Conversions Between CLOB and VARCHAR2Implicit conversions from CLOB to VARCHAR2 and from VARCHAR2 to CLOB datatypes are allowed in PL … columns can be selected into VARCHAR2 PL/SQL variables VARCHAR2 columns can be selected into CLOB … variables Assignment and parameter passing between CLOBs and VARCHAR2s Accessing a CLOB as a VARCHAR2

Packages and Types Reference, 10g Release 1 (10.1)

173 JMS Types

write_utf (id IN PLS_INTEGER, value IN VARCHAR2)Writes a string to the bytes message stream using UTF-8 encoding in a machine-independent manner. Raises exception ORA-24196 if the bytes message is in write-only mode, ORA-24197 if the Java stored procedure throws an exception during execution, or ORA-24198 if the operation ID is invalid.

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

9 SQL Semantics and LOBs

VARCHAR2 and RAW Semantics for LOBsThe following semantics, used with VARCHAR2 and RAW datatypes, also apply to LOBs: Defining a CHAR … buffer on a CLOB You can define a VARCHAR2 for a CLOB and RAW for a BLOB column. You can also define … CLOB and BLOB types for VARCHAR2 and RAW columns. Selecting a CLOB column into a CHAR buffer or … VARCHAR2

Packages and Types Reference, 10g Release 1 (10.1)

173 JMS Types

get_short (id IN PLS_INTEGER, name IN VARCHAR2) RETURN PLS_INTEGERRetrieves the short value with the specified name. If there is no item by this name, then is returned. Because there is no short type in PL/SQL, INT is used to represent a short. Although the PL/SQL users get an PLS_INTEGER, they are guaranteed that the value is in the Java short value range. If this value is issued with a set_short function, then there will not be an out of range error. Raises exception

Packages and Types Reference, 10g Release 1 (10.1)

173 JMS Types

set_int (id IN PLS_INTEGER, name IN VARCHAR2, value IN PLS_INTEGER)Sets the int value with the specified name in the map. Raises exception ORA-24197 if the Java stored procedure throws an exception during execution or ORA-24198 if the operation ID is invalid.