Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

Oracle - Data Types

Versions: Oracle 11g, 10g, 9i, 8i and 7.3

Data Type Parameters and Range
Character Data Types
CHAR(n) - Fixed-length character data 1 ⇐ n ⇐ 2000/charsize, default is 1
NCHAR(n) - Fixed-length character data in Unicode 1 ⇐ n ⇐ 2000/charsize, default is 1
VARCHAR2(n) - Variable-length character data 1 ⇐ n ⇐ 4000/charsize, n is mandatory
NVARCHAR2(n) - Variable-length character data in Unicode 1 ⇐ n ⇐ 4000/charsize, n is mandatory
CLOB - Variable-length character data (large object) 4G
NCLOB - Variable-length character data in Unicode (large object) 4G
LONG - Variable-length character data 2G, backward compatibility - not recommended for use
Numeric Data Types
NUMBER(p,s) - Integer, decimal and floating-point numeric data 1 ⇐ p ⇐ 38, default is 38; -84 ⇐ s ⇐ 127, default is 0
FLOAT(p) - Floating-point numeric data 1 ⇐ p ⇐ 126, default is 126
BINARY_FLOAT - Floating-point numeric data 1.17E-38 to 3.40E+38, special values: INF and NaN
BINARY_DOUBLE - Floating-point numeric data 2.22E-308 to 1.79E+308, special values: INF and NaN
Date and Time Data Types
DATE - Date and time data (day, month, year, hours, minutes and seconds) January 1, 4712 BC 00:00:00 to December 31, 9999 23:59:59
TIMESTAMP(p) - Date and time data (day, month, year, hours, minutes,
seconds and fractional seconds)
January 1, 4712 BC 00:00:00.0(9) to December 31, 9999 23:59:59.0(9)
0 ⇐ p ⇐ 9, default is 6 (microseconds)
INTERVAL YEAR(p) TO MONTH - Period of time in years and months 0 ⇐ p ⇐ 9, default is 2
INTERVAL DAY(p1) TO SECOND(p2) - Period of time in days, hours, minutes,
seconds and fractional seconds
0 ⇐ p1 ⇐ 9, default is 2 ; 0 ⇐ p2 ⇐ 9 , default is 6
Binary Data Types
RAW(n) - Variable-length binary data 1 ⇐ n ⇐ 2000
LONG RAW - Variable-length binary data 2G, not recommended for use
BLOB - Variable-length binary data (binary large object) 4G
Other Data Types
BFILE - Pointer to binary file 264 - 1 bytes
ROWID - Physical row address Data returned by rowid pseudocolumn
UROWID(p) - Logical row addresses 1 ⇐ p ⇐ 4000, default is 4000

Data Types in Other Databases


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

sqlways/oracle/data-types.txt · Last modified: May 07, 2018, 03:15:28 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement