Scribd
Upload
131 views

Cheat Sheet Data Type Oracle

The document summarizes Oracle data types. It lists numeric, character, date, and other data types including their descriptions and capabilities. Numeric types store numbers and include NUMBER, FLOAT, BINARY_FLOAT, BINARY_DOUBLE, INTEGER. Character types store text and include VARCHAR2, CHAR, NCHAR, CLOB, NCLOB. Date types store dates and times, including DATE, TIMESTAMP, INTERVAL. Other types include ROWID, UROWID, BLOB for binary objects, and BFILE for external files.

Uploaded by

daemi
Copyright
© © All Rights Reserved
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
131 views

Cheat Sheet Data Type Oracle

The document summarizes Oracle data types. It lists numeric, character, date, and other data types including their descriptions and capabilities. Numeric types store numbers and include NUMBER, FLOAT, BINARY_FLOAT, BINARY_DOUBLE, INTEGER. Character types store text and include VARCHAR2, CHAR, NCHAR, CLOB, NCLOB. Date types store dates and times, including DATE, TIMESTAMP, INTERVAL. Other types include ROWID, UROWID, BLOB for binary objects, and BFILE for external files.

Uploaded by

daemi
Copyright
© © All Rights Reserved
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
You are on page 1/ 1

Oracle Data Types

www.databasestar.com
Numeric Character

Numeric data, with a precision of p and scale of s. Precision p CHAR (s) Fixed-length character with a length of s.
NUMBER (p, s)
ranges from 1 to 38, and scale ranges from -84 to 127 Up to 2,000 bytes.
Range: -10^38 +1 through 10^38 - 1
NCHAR (s) Fixed length national character with a length of s.
BINARY_FLOAT Up to 2,000 bytes.
32-bit, single-precision floating-point number
Range: from 1.17549E-38F to 3.40282E+38F
VARCHAR Not implemented in Oracle.

BINARY_DOUBLE 64-bit, double-precision floating-point number


Range: From 2.22507485850720E-308 to VARCHAR2 (s) Variable-length character string with a maximum length of s
1.79769313486231E+308 bytes.
Up to 32,767 bytes

INTEGER Synonym for NUMBER(38)


NVARCHAR2 (s) Variable-length national character string with a maximum length
Range: -10^38 +1 through 10^38 - 1
of s bytes.
Up to 32,767 bytes
FLOAT Translated to NUMBER.
Range: 1 to 126 binary digits, and up to 22 bytes
LONG Variable-length character string. Larger than VARCHAR2.
Deprecated.
DECIMAL Translated to NUMBER. Up to 2GB
Range: 1 to 126 binary digits, and up to 22 bytes
RAW (s) Raw binary data of length size.
NUMERIC Synonym for NUMBER Up to 32,767 bytes

INT Synonym for NUMBER(38) LONG RAW Raw binary data of variable length. Deprecated.
Up to 2 GB
SMALLINT Synonym for NUMBER(38)
CHARACTER Synonym for VARCHAR2
VARYING
DOUBLE PRECISION Synonym for FLOAT(126)
CHARACTER Synonym for CHAR

REAL Synonym for FLOAT(63)


BLOB Stores large unstructured binary objects. Recommended for
JSON fields before Oracle 21c
Up to 8 TB to 128 TB (4 GB -1 * (database block size))

Date
CLOB Stores large single-byte and multi-byte objects.
Up to 8 TB to 128 TB (4 GB -1 * (database block size))
DATE Stores date and time values.
From Jan 1, 4712 BC to Dec 31 9999 AD NCLOB Stores Unicode data.
Up to 8 TB to 128 TB (4 GB -1 * (database block size))
TIMESTAMP [(p)] A date value that stores time and fractional seconds.
From Jan 1, 4712 BC to Dec 31 9999 AD. Fractional seconds (p) JSON Data type to store JSON data. New in Oracle 21c
must be 0 to 9

TIMESTAMP [(p)] A timestamp that stores data in the specified timezone


WITH TIME From Jan 1, 4712 BC to Dec 31 9999 AD. Fractional seconds Other
ZONE (p) must be 0 to 9

BFILE A file locator that points to a file on the server.


TIMESTAMP [(p)] A timestamp that stores data in your local timezone. Up to 4GB
WITH LOCAL From Jan 1, 4712 BC to Dec 31 9999 AD. Fractional seconds (p)
TIME ZONE must be 0 to 9
ROWID Fixed-length binary data for a database row ID.
Up to 10 bytes
INTERVAL YEAR Stores a period of time in years and months. Up to 2 digits in the
[(p)] TO MONTH year
UROWID Universal RowID.
Up to 4,000 bytes
INTERVAL DAY Stores a period of time in days, hours, minutes, and seconds.
[(p)] TO SECOND Between 0 and 9 digits in the day, between 0 and 9 digits
fractional seconds

You might also like