Quantcast
OracleBrains.Com header image 2

Maximum Length of various Datatypes

December 15th, 2006 by Rajender Singh · 1 Comment

When doing research for Internal Datatypes in Oracle I though of sharing and publising following information with the guys who are new to Oracle:

Datatype Name Maximum Length
BFILE 4 gigabytes
CHAR, NCHAR 2000 bytes
DATE 7 bytes
INTERVAL DAY TO SECOND REF 11 bytes
INTERVAL YEAR TO MONTH REF 5 bytes
LONG 2 gigabytes (2^31-1 bytes)
LONG RAW 2 gigabytes (2^31-1 bytes)
NUMBER 21 bytes
RAW 2000 bytes
REF BLOB 4 gigabytes
REF CLOB, REF NCLOB 4 gigabytes
ROWID 10 bytes
TIMESTAMP 11 bytes
TIMESTAMP WITH LOCAL TIME ZONE 7 bytes
TIMESTAMP WITH TIME ZONE 13 bytes
UROWID 4000 bytes
VARCHAR2, NVARCHAR2 4000 bytes

Tags: Oracle Administration · Oracle Database · SQL and PL/SQL

1 response so far ↓

Leave a Comment