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 CHAR


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


Concepts and Administration, 10g Release 1 (10.1)

4 Creating a Logical Standby Database

CHARNCHAR

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

3 Datatypes

CHARThe CHAR datatype is a string of characters, with a maximum length of 2000. CHAR strings are … converted to internal numeric format. If the CHAR string contains an illegal conversion character, Oracle

DML Reference, 10g Release 1 (10.1)

LIKEESCAPE

charA text expression that specifies the character to use as an escape character in a LIKE text comparison. The default is no escape character. The LIKE escape character affects the LISTNAMES program, which accepts a LIKE argument that it uses in a LIKE text comparison. Notes Using the Escape Character The LIKE escape character lets you find text expressions that contain the LIKE operator wildcard characters,

Concepts, 10g Release 1 (10.1)

26 Native Datatypes

CHAR DatatypeThe CHAR datatype stores fixed-length character strings. When you create a table with a CHAR column … , you must specify a string length (in bytes or characters) between 1 and 2000 bytes for the CHAR … the table, the value for the CHAR column has the fixed length. If you give a shorter value, then the … compares

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Numb er Class

operator char()This method returns the value of the Number object converted to a native char. Syntax operator char() const;

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Numb er Class

operator unsigned char()This method returns the value of the Number object converted to a native unsigned char. Syntax operator unsigned char() const;

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 … both values being compared in a SQL statement belong to type CHAR, blank-padding semantics are used … the length of the longer value. For example, if ENAME is a CHAR database column and emp_name is a

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Numb er Class

operator signed char()This method returns the value of the Number object converted to a native signed char. Syntax operator signed char() const;

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

10 Oracle Extensions

10.4.1 SQL CHAR DatatypesThe SQL CHAR datatypes include CHAR, VARCHAR2, and CLOB. These datatypes allow you to store

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

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

Inserting Character Valuesa character value into a CHAR database column, Oracle does not strip trailing blanks. If the value

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

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

Comparing Character Valuesbeing compared have equal lengths. If both values in a comparison have datatype CHAR, blank-padding … shorter value to the length of the longer value. For example, given the declarations last_name1 CHAR(5 … ):= 'BELLO'; last_name2 CHAR(10):= 'BELLO '; -- note trailing blanks the following IF condition is … false: IF last_name1

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

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

Selecting Character Valuesa column value into a CHAR variable, if the value is shorter than the declared length of the … example, when you select a blank-padded CHAR column value into a VARCHAR2 variable, the trailing blanks

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

B Understanding CHAR and VARCHAR2 Semantics in PL/SQL

Assigning Character ValuesWhen you assign a character value to a CHAR variable, if the value is shorter than the declared … includes six trailing blanks, not just one: last_name CHAR(10):= 'CHEN '; -- note trailing blank If the … character value is longer than the declared length of the CHAR variable, PL/SQL aborts the … trim trailing blanks. For example,

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

SQL Reference, 10g Release 1 (10.1)

Format Models

char 'fmt' Match or Error?Table 2-18 Matching Character Data and Format Models with the FX Format Model Modifier char 'fmt

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

4 Basic Features

4.4.2 Streaming CHAR, VARCHAR, or RAW ColumnsIf you use the defineColumnType() Oracle extension to redefine a CHAR, VARCHAR, or RAW column as a … , because these columns are usually short. If you try to get a CHAR, VARCHAR, or RAW column as a data

Globalization Support Guide, 10g Release 1 (10.1)

2 Choosing a Character Set

Abstract Datatype CHAR NCHAR BLOB CLOB NCLOBTable 2-7 Abstract Datatype Support for SQL Datatypes Abstract Datatype CHAR NCHAR BLOB CLOB NCLOB

Globalization Support Guide, 10g Release 1 (10.1)

11 Character Set Migration

Migrating CHAR Columns to NCHAR Columns: Using the ALTER TABLE MODIFY Statement to Change CHAR Columns to NCHAR Columns Using Online Table … CHAR Columns to NCHAR Columns The ALTER TABLE MODIFY statement can be used to change table column … definitions from the CHAR datatypes to NCHAR datatypes. It also converts all of the data in the column

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

173 JMS Types

read_char (id IN PLS_INTEGER) RETURN CHARReads a character value from the bytes message and returns the character value read. Null is returned if the end of the stream has been reached. 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.

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

173 JMS Types

write_char (id IN PLS_INTEGER, value IN CHAR)Writes a character value to the bytes message. If this value has multiple characters, it is the first character that is written. 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.