Scribd
Upload
4 views2 pages

Oracle Data Types

Fixed-length character Fixed for every row in the table (with trailing data of length size blanks); maximum size is 2000 bytes per row, bytes or characters. Default size is 1 byte per row. Consider the character set (single-byte or multibyte) before setting size. A maximum size must be specified. Fixed-length date and time data, ranging from Jan. 1, 4712 B.C.E. To Dec. 31, 4712 C.E. Fixed at 7 bytes for each row in the

Uploaded by

ashish123_gec
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Oracle Data Types

Fixed-length character Fixed for every row in the table (with trailing data of length size blanks); maximum size is 2000 bytes per row, bytes or characters. Default size is 1 byte per row. Consider the character set (single-byte or multibyte) before setting size. A maximum size must be specified. Fixed-length date and time data, ranging from Jan. 1, 4712 B.C.E. To Dec. 31, 4712 C.E. Fixed at 7 bytes for each row in the

Uploaded by

ashish123_gec
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

CS 649 Database Management Systems

Oracle Data Types

CHAR (size Fixed-length character Fixed for every row in the table (with trailing
[BYTE | data of length size blanks); maximum size is 2000 bytes per row,
CHAR])
bytes or characters. default size is 1 byte per row. Consider the
character set (single-byte or multibyte) before
setting size.
VARCHAR2 Variable-length Variable for each row, up to 4000 bytes per row.
(size [BYTE
character data, with Consider the character set (single-byte or
| CHAR])
maximum length size multibyte) before setting size. A maximum size
bytes or characters. must be specified.
NCHAR Fixed-length Unicode Fixed for every row in the table (with trailing
(size)
character data of blanks). Column size is the number of characters.
length size characters. (The number of bytes is 2 times this number for
the AL16UTF16 encoding and 3 times this number
for the UTF8 encoding.) The upper limit is 2000
bytes per row. Default is 1 character.
NVARCHAR2 Variable-length Variable for each row. Column size is the number
(size) Unicode character data of characters. (The number of bytes may be up to
of length size 2 times this number for a the AL16UTF16 encoding
characters. A and 3 times this number for the UTF8 encoding.)
maximum size must be The upper limit is 4000 bytes per row. Default is 1
specified. character.
CLOB Single-byte character Up to 232 - 1 bytes, or 4 gigabytes.
data
NCLOB Unicode national Up to 232 - 1 bytes, or 4 gigabytes.
character set (NCHAR)
data.
LONG Variable-length Variable for each row in the table, up to 232 - 1
character data. bytes, or 2 gigabytes, per row. Provided for
backward compatibility.
NUMBER (p, Variable-length Variable for each row. The maximum space
s) numeric data. required for a given column is 21 bytes per row.
Maximum precision p
and/or scale s is 38.
DATE Fixed-length date and Fixed at 7 bytes for each row in the table. Default
time data, ranging format is a string (such as DD-MON-RR) specified by
from Jan. 1, 4712 the NLS_DATE_FORMAT parameter.
B.C.E. to Dec. 31,
4712 C.E.

Page 1
CS 649 Database Management Systems

BLOB Unstructured binary data Up to 232 - 1 bytes, or 4 gigabytes.


BFILE Binary data stored in an Up to 232 - 1 bytes, or 4 gigabytes.
external file
RAW Variable-length raw binary Variable for each row in the table, up to 2000
(size) data bytes per row. A maximum size must be specified.
Provided for backward compatibility.
LONG RAW Variable-length raw binary Variable for each row in the table, up to 231 - 1
data bytes, or 2 gigabytes, per row. Provided for
backward compatibility.
ROWID Binary data representing Fixed at 10 bytes (extended ROWID) or 6 bytes
row addresses (restricted ROWID) for each row in the table.

Page 2

You might also like