C
Oracle Lite Literals

C.1 CHAR, VARCHAR

Character string literal value.

'<letters>'

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

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.

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

C.2 DATE

Date literal value.

[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]

<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).

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

C.3 DECIMAL, NUMERIC, NUMBER

Decimal number literal value.

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

<digits> a sequence of one or more digits.

54321
-123.
+456
64591.645
+.12345
0.12345

C.4 REAL, FLOAT, DOUBLE PRECISION

Floating point number literal value.

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

<digits> a sequence of one or more digits.

<exp>'E' or 'e'.

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

C.5 SMALLINT, INTEGER, BIGINT, TINYINT

[ODBC]

Integer literal value.

[+|- ]<digits>

<digits> a sequence of one or more digits.

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

12345

C.6 TIME

Time literal value.

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

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

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

C.7 TIMESTAMP

Timestamp literal value.

TIMESTAMP ' <DATE_literal_value > <TIME_literal_value >'

<DATE_literal_value> a Date literal.

<TIME_literal_value> a Time literal.

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

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