Oracle7 Server SQL Reference

Contents Index Home Previous Next

Number

Purpose

To specify an integer or a real number. You must use this notation to specify values whenever number appears in expressions, conditions, SQL functions, and SQL commands in other parts of this manual.

Syntax

Keywords and Parameters

+, - indicates a positive or negative value. If you omit the sign, a positive value is the default.

digit

is one of 0, 1, 2, 3, 4, 5, 6, 7, 8 or 9.

e, E

indicates that the number is specified in scientific notation. The digits after the E specify the exponent. The exponent can range between -130 and 125.

Usage Notes

A number can store a maximum of 38 digits of precision.

If you have established a decimal character other than a period (.) with the initialization parameter NLS_NUMERIC_CHARACTERS, you must specify numeric literals with 'text' notation. In such cases, Oracle7 automatically converts the text literal to a numeric value.

For more information on this parameter, see Oracle7 Server Reference.

Examples

25

+6.34
0.5
25e-03
-1

Related Topics

The syntax description of expr [*].

Contents Index Home Previous Next