Results for CHAR


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


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

Datatypes

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

Concepts and Administration, 9i Release 2 (9.2.0.2)

Creating a Logical Standby Database

CHARNCHAR

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

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

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

CHAR versus VARCHAR2 Semantics

Assigning Character ValuesSelecting Character Values Assigning Character Values When you assign a character value to a CHAR … , the value assigned to last_name 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 CHARCHAR(4);

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

CHAR versus VARCHAR2 Semantics

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

Objects for OLE, 9i Release 2 (9.2.0.2)

operator const char *

operator const char *Master Index Feedback operator const char * Applies To OField, OParameter OValue Description This … method returns the object's value as a string. Usage operator const char * () const Remarks This … destroyed or closed or when another const char * cast is made. Return Value A valid, -terminated … const char pointer

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

CHAR versus VARCHAR2 Semantics

Comparing Character Valuesbeing compared have equal lengths. So, if both values in a comparison have datatype CHAR, blank-padding … CHAR(5):= 'BELLO'; last_name2 CHAR(10):= 'BELLO '; -- note trailing blanks the following IF … datatype VARCHAR2 and the other value has datatype CHAR, non-blank-padding semantics are used. But … , remember,

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

Reference Guide for Informix Dynamic Server Migrations, 9i Release 2 (9.2.0.2)

Oracle and Informix Dynamic Server Compared

CHAR(n)The Informix Dynamic Server CHAR datatype stores any sequence of letters, numbers, and symbols. It … handling large Informix Dynamic Server CHAR datatypes should be reasonably efficient when stored in … ); You can use subscripts on BYTE columns. Subscripts can also be used on CHAR, VARCHAR2, NCHAR, NVARCHAR … the CLOB, using READ

Concepts, 9i Release 2 (9.2.0.2)

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 … . Oracle

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

Package oracle.jms

writeChar(char)public void writeChar(char value) Write a char to the stream message as a 2-byte value, high byte … first. Specified By javax.jms.BytesMessage.writeChar(char) in interface javax.jms.BytesMessage … Parameters value - the char value to be written. Throws MessageNotWriteableException - if message in read

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

Package oracle.jms

writeChar(char)public void writeChar(char value) Write a char to the stream as a 2-byte, high byte first Specified … By javax.jms.StreamMessage.writeChar(char) in interface javax.jms.StreamMessage Parameters value … - the char to be written Throws MessageNotWritableException - if message in write-only mode

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 14 of 22

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, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 14 of 22

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

Precompilers, 9i Release 2 (9.2.0.2)

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

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

Package oracle.xml.parser.v2

comment(char[], int, int)Description Report an XML comment anywhere in the document. Syntax public void comment(char[] ch

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

Overview of Oracle Extensions

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

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

Package oracle.xml.parser.v2

characters(char[], int, int)(char[] ch, int start, int length) Parameters ch - The characters. start - The start position in the

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

Package oracle.xml.parser.v2

ignorableWhitespace(char[], int, int)ignorableWhitespace(char[] ch, int start, int length) Parameters ch - The whitespace characters. start





Was this page helpful?

Integrated Cloud Applications & Platform Services