Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle data-types list?
On Wed, 9 Jun 1999 10:16:32 -0400, "Dan Duda" <danduda_at_mindspring.com> wrote:
>Could someone post the list of all Oracle datatypes or point me to a web
>site with them? Thanks.
>
Built-In Datatypes of Oracle 8i
CHAR
VARCHAR2
NCHAR
NVARCHAR2
LONG
NUMBER
DATE
RAW
LONG RAW
BLOB
CLOB
NCLOB
BFILE
ROWID
UROWID
CHAR(size)
Fixed-length character data of length size bytes.
Fixed for every row in the table (with trailing blanks); maximum size is 2000 bytes per row, default size is 1 byte per row. Consider the character set (one-byte or multibyte) before setting size.
VARCHAR2(size)
Variable-length character data. A maximum size must be specified.
Variable for each row, up to 4000 bytes per row. Consider the character set (one-byte or multibyte) before setting size.
NCHAR(size)
Fixed-length character data of length size
characters or bytes, depending on the
national character set.
Fixed for every row in the table (with trailing blanks). Column size is the number of characters for a fixed-width national character set or the number of bytes for a varying-width national character set. Maximum size is determined by the number of bytes required to store one character, with an upper limit of 2000 bytes per row. Default is 1 character or 1 byte, depending on the character set.
NVARCHAR2(size)
Variable-length character data of
length size characters or bytes, depending
on national character set. A maximum size
must be specified.
Variable for each row. Column size is the number of characters for a fixed-width national character set or the number of bytes for a varying-width national character set. Maximum size is determined by the number of bytes required to store one character, with an upper limit of 4000 bytes per row. Default is 1 character or 1 byte, depending on the character set.
LONG Variable-length character data.
Variable for each row in the table, up to 2^31 - 1 bytes, or 2 gigabytes, per row.
NUMBER(p, s)
Variable-length numeric data.
Maximum precision p and/or scale s is 38. Variable for each row. The maximum space required for a given column is 21 bytes per row.
DATE Fixed-length date and time data, ranging from January 1, 4712 BCE to December 31, 4712 CE ("A.D.")
Fixed at 7 bytes for each row in the table. Default format is a string (such as DD-MON-YY) specified by NLS_DATE_FORMAT parameter.
RAW(size)
Variable-length raw binary data. A
maximum size must be specified.
Variable for each row in the table, up to 2000 bytes per row.
LONG RAW Variable-length raw binary data.
Variable for each row in the table, up to 2^31 -1 bytes, or 2 gigabytes, per row.
BLOB Binary data.
Up to 2^32 - 1 bytes, or 4 gigabytes.
CLOB Single-byte character data.
Up to 2^32 - 1 bytes, or 4 gigabytes.
NCLOB
Single-byte or fixed-or variable-width
multibyte national character set
(NCHAR) data.
Up to 2^32 - 1 bytes, or 4 gigabytes.
BFILE Binary data stored in an external file.
Up to 2^32 - 1 bytes, or 4 gigabytes.
ROWID Binary data representing a physical row address.
Fixed at 10 bytes (extended ROWID) or 6 bytes (restricted ROWID) for each row in the table.
UROWID
Binary data representing any type
of row address: physical, logical, or
foreign.
Up to 4000 bytes (but for a logical ROWID, only 3950 bytes can be used for the primary key). The default is 4000 bytes.
You can check the Concepts Manual, chapter 13, Built-In Datatypes, for more info on each of them.
hope this helps.
chris.
--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.