MIME-Version: 1.0 Content-Location: file:///C:/8F7E4D13/Oracle8DataTypes.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"
Oracle 8 Data Types
Code
|
Internal Dat=
atype
|
Description |
1 |
VARCHAR2(= size) NVARCHAR2(size) |
Variable length character string having maximum leng=
th size bytes. Maximum size is 4000, and minimum is 1. =
You
must specify size for a VARCH=
AR2. Variable-length character string having maximum leng= th size characters or bytes, depend= ing on the choice of national character set. Maximum size is determined by the number of bytes required to store e= ach character, with an upper limit of 4000 bytes. You must specify size for NVARCHAR2. |
2 |
NUMBER(p,s) |
Number having precision p and scale s. The precision p can range from 1 = to 38. The scale s can range from -8= 4 to 127. |
8 |
LONG |
Character data of variable length up to 2 gigabytes,= or 231 -1 bytes. |
12 |
DATE |
Valid date range from January 1, 4712 BC to December= 31, 4712 AD. |
23 |
RAW(size<= /i>) |
Raw binary data of length size bytes. Maximum s= ize is 2000 bytes. You must specify s= ize for a RAW value. |
24 |
LONG RAW |
Raw binary data of variable length up to 2 gigabytes= . |
69 |
ROWID (see note below) |
Hexadecimal string representing the unique address o= f a row in its table. This datatype is primarily = for values returned by the ROWID pseudocolumn. = p> |
96 |
CHAR(size= ) NCHAR(siz= e) |
Fixed length character data of length size bytes. Maximum s= ize is 2000 bytes. Default and minimum size is 1 byte. Fixed-length character data of length size characters or bytes, depending on the choice of national character set. Maximum size is determined by the number of bytes required to store each character, with = an upper limit of 2000 bytes. Default and minimum size is 1 character or 1 byte, depending on the character set= . |
106 |
MLSLABEL |
Binary format of an operating system label. This |
112 |
CLOB NCLOB |
A character large object containing single byte characters. Varying-width character sets are not supported. Maximum size = is 4 gigabytes. A character large object containing fixed-width mult= i-byte characters. Varying-width character sets are not supported. Maximum size = is 4 gigabytes. Stores national character set data. |
113 |
BLOB |
A binary large object. Maximum size is 4 gigabytes. = |
114 |
BFILE |
Contains a locator to a large binary file stored out= side the database. Enables byte stream I/O access to external LOBs residing on the database server. Maximum size is 4 gigabytes. |