Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
503
A. Oracle Built-In Data Types
This chapter describes Oracle built-in data types used in Prime Optical tables.
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.
BFILE
Binary data that is stored in an external file.
BLOB
Binary data.
CHAR(size)
Fixed-length character data of length-size
bytes.
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.).
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.
characters or bytes, depending on the
national character set.
NCLOB
Single-byte or fixed-length multibyte national
character set (NCHAR) data.
character set (NCHAR) data.
NUMBER(p, s)
Variable-length numeric data. Maximum
precision p and/or scale s is 38.
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.
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.
specify a maximum size.
ROWID
Binary data representing row addresses.
VARCHAR2(size)
Variable-length character data. You must
specify a maximum size.
specify a maximum size.