This chapter describes Oracle built-in data types used in Prime Optical tables.
Note The information in the following table is provided as a reference only. For additional information about Oracle built-in data types, refer to Oracle documentation.
Table A-1 Oracle Built-in Data Types
Data Type
Description
BFILE
Binary data that is stored in an external file.
BLOB
Binary data.
CHAR(size)
Fixed-length character data of length-size bytes.
CLOB
Single-byte character data.
DATE
Fixed-length date and time data, ranging from January 1, 4712 BCE (B.C.) to December 31, 4712 CE (A.D.).
FLOAT(n)
Decimal data type.
LONG
Variable-length character data.
LONG RAW
Variable-length raw binary data.
MLSLABEL
Trusted Oracle data type.
NCHAR(size)
Fixed-length character data of length-size characters or bytes, depending on the national character set.
NCLOB
Single-byte or fixed-length multibyte national character set (NCHAR) data.
NUMBER(p, s)
Variable-length numeric data. Maximum precision p and/or scale s is 38.
NVARCHAR2(size)
Variable-length character data of length-size characters or bytes, depending on the national character set. You must specify a maximum size.
RAW(size)
Variable-length raw binary data. You must specify a maximum size.
ROWID
Binary data representing row addresses.
VARCHAR2(size)
Variable-length character data. You must specify a maximum size.
Feedback
The information in the following table is provided as a reference only. For additional information about Oracle built-in data types, refer to Oracle documentation.
