Literal

A literal is value that is not represented by an identifier or an expression.

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

numeric_literal ::=

Description of the illustration numeric_literal.gif

integer ::=

Description of the illustration integer.gif

real_number ::=

Description of the illustration real_number.gif

character_literal ::=

Description of the illustration character_literal.gif

string_literal ::=

Description of the illustration string_literal.gif

boolean_literal ::=

Description of the illustration boolean_literal.gif

Semantics

numeric_literal

d or D

Specifies that the numeric literal has the data type BINARY_DOUBLE.

f or F

Specifies that the numeric literal has the data type BINARY_FLOAT.

integer

digit

The character 0, 1, 2, 3, 4, 5, 6, 7, 8, or 9.

real_number

e or E

Introduces the exponent.

character_literal and string_literal

character

A member of the PL/SQL character set. For information about the PL/SQL character set, see"Character Sets".

Examples

• Example 2-4, "Datetime and Interval Literals"

• Example 2-59, "Compiling Different Code for Different Database Versions"

Related Topics

In this chapter:

• "Constant"

• "Expression"

In other chapters:

• "Literals"