The value for day_precision is from 0 to 9, with a default of
2. The value of fractional_seconds_precision is similar to the fractional
seconds in a TIMESTAMP value; the range is from 0 to 9, with a default
of 6.
RAW(size) Raw binary data, with a maximum size of 2000 bytes.
TABLE 1-1 Oracle Built-in Datatypes
10 Oracle Database 11g DBA Handbook
Oracle Built-in Datatype Description
LONG RAW Raw binary data, variable length, up to 2GB in size.
ROWID A base-64 string representing the unique address of a row in its
corresponding table. This address is unique throughout the database.
UROWID [(size)] A base-64 string representing the logical address of a row in an indexorganized
table. The maximum for size is 4000 bytes.
CHAR(size) [ BYTE | CHAR ] A fixed- length character string of length size. The minimum size is 1,
and the maximum is 2000 bytes. The BYTE and CHAR parameters are
BYTE and CHAR semantics, as in VARCHAR2.
NCHAR(size) A fixed-length character string up to 2000 bytes; the maximum size
depends on the national character set definition for the database. The
default size is 1.
CLOB A character large object containing single-byte or multibyte characters;
supports both fixed-width or variable-width character sets. The
maximum size is (4GB ??“ 1) * DB_BLOCK_SIZE.
NCLOB Similar to CLOB, except that Unicode characters are stored from either
fixed-width and variable-width character sets. The maximum size is
(4GB ??“ 1) * DB_BLOCK_SIZE.
Pages:
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66