Oracle7 Server SQL Reference

Text

Purpose

To specify a text or character literal. You must use this notation to specify values whenever 'text' or char appear in expressions, conditions, SQL functions, and SQL commands in other parts of this manual.

Syntax

Keywords and Parameters

is any member of the user's character set, except a single quotation mark (').

are two single quotation marks. Because a single quotation mark is used to begin and end text literals, you must use two single quotation marks to represent one single quotation mark within a literal.

Usage Notes

A text literal must be enclosed in single quotation marks. This manual uses the terms text literal and character literal interchangeably.

Text literals have properties of both the CHAR and VARCHAR2 datatypes:

Within expressions and conditions, Oracle7 treats text literals as though they have the datatype CHAR by comparing them using blank-padded comparison semantics.

A text literal can have a maximum length of 2000 bytes.

Examples

'Hello'

'ORACLE.dbs'

'Jackie''s raincoat'

'09-MAR-92'

Text

Purpose

Syntax

Keywords and Parameters

Usage Notes

Related Topics