D Oracle Database Lite Literals

Oracle Lite supports the following literals:

Section D.1, "CHAR, VARCHAR"
Section D.2, "DATE"
Section D.3, "DECIMAL, NUMERIC, NUMBER"
Section D.4, "REAL, FLOAT, DOUBLE PRECISION"
Section D.5, "SMALLINT, INTEGER, BIGINT, TINYINT"
Section D.6, "TIME"
Section D.7, "TIMESTAMP"

D.1 CHAR, VARCHAR

Character string literal value.

Syntax

'<letters>'

Keywords and Parameters

<letters> a sequence of zero or more printable characters excluding new-line.

Usage Notes

If a single quote is part of a literal, it must be preceded by another single quote (used as an escape character). The maximum length of a character literal is 1024.

Examples

'a string'
'a string containing a quote '''

D.2 DATE

Date literal value.

Syntax

[DATE] ' <year1 ><month1 ><day >' [SQL-92]
{ d ' <year1 ><month1 ><day >' [ODBC]
--(* d ' <year1 ><month1 ><day >' *)-- [ODBC]
' <day ><month2 ><year2 >' [Oracle]
' <day ><month2 ><year1 >' [Oracle]
' <month1 ><day ><year2 >' [Oracle]
' <month1 ><day ><year1 >' [Oracle]

Keywords and Parameters

<year1> a four-digit number representing a year, for example, 1994.

<year2> a two-digit number representing the last two digits of a year.

<month1> a two-digit number between 01 and 12.

<month2> a three-letter initial of a month (this is not case-sensitive).

<day> a two-digit number between 01 and 31 (depending on the month).

Examples

'1994-11-07' [SQL-92]
{ d '1994-11-07' }
--(* d '1994-11-07' *)--
DATE '10-23-94'
'23-Nov-1994' [Oracle]
'23-Nov-94'

D.3 DECIMAL, NUMERIC, NUMBER

Decimal number literal value.

Syntax

[+|- ]<digits>
[+|- ]<digits>.[<digits>]
[+|- ].<digits>

Keywords and Parameters

<digits> a sequence of one or more digits.

Examples

D.4 REAL, FLOAT, DOUBLE PRECISION

Floating point number literal value.

Syntax

[+|- ]<digits ><exp >[+|- ]<digits >
[+|- ]<digits >. [<digits >]<exp >[+|- ]<digits >
[+|- ].<digits ><exp >[+|- ]<digits >

Keywords and Parameters

<digits> a sequence of one or more digits.

<exp>'E' or 'e'.

Examples

+1.5e-7
12E-5
-.12345e+6789

D.5 SMALLINT, INTEGER, BIGINT, TINYINT

[ODBC]

Integer literal value.

Syntax

[+|- ]<digits>

Keywords and Parameters

<digits> a sequence of one or more digits.

Usage Notes

Let n be the number the literal represents.

For TINYINT, -128 <= n <= 127

For a SMALLINT, -32768 <= n <= 32767

For an INTEGER, -2^31 < n < 2^31

For a BIGINT, -10^19 < n < 10^19

Example

D.6 TIME

Time literal value.

Syntax

[TIME]' <hour>:<minute>:<second>[.[<fractional_second>]]'

Keywords and Parameters

<hour> a two-digit number between 00 and 23.

<minute> a two-digit number between 00 and 59.

<second> a two-digit number between 00 and 59.

<fractional_second> a number containing up to 6 digits.

Examples

'23:00:00'
TIME '23:00:00.'
TIME '23:01:59.134343'

D.7 TIMESTAMP

Timestamp literal value.

Syntax

TIMESTAMP ' <DATE_literal_value > <TIME_literal_value >'

Keywords and Parameters

<DATE_literal_value> a Date literal.

<TIME_literal_value> a Time literal.

Usage Notes

In a timestamp literal, there is exactly one space character between the Date literal and the Time literal.

Examples

TIMESTAMP '1994-11-07 23:00:00'
'94-06-01 12:02:00'
Examples: CHAR (10)