Question: What are the
maximum values for Oracle column datatypes?
Answer: The table below gives the
maximum values for the most common Oracle datatypes. Note that
the BFILE datatype stored objects outside of Oracle at the filesystem
level, and that the maximum size of a directory name is 30 characters
and the maximum size of a file name is 255 characters:
|
BFILE
|
Maximum size is 4 GB
|
|
BLOB
|
Maximum size is ((4 GB – 1) * db_block_size)
|
|
CHAR
|
Maximum size is 2,048 bytes
|
|
CHAR
VARYING
|
Maximum size is 4,096 bytes
|
|
CLOB
|
Maximum size is ((4 GB – 1) * db_block_size)
|
|
LONG
|
Maximum size is (2 GB – 1)
|
|
NCHAR
|
Maximum size is 2,048 bytes
|
|
NCHAR VARYING
|
Maximum size is 4,096 bytes
|
|
NCLOB
|
Maximum size is ((4 GB – 1) * db_block_size)
|
|
NUMBER
|
999…(38 9’s) x10125 maximum value
|
|
RAW
|
Maximum size is 2,048 bytes
|
|
VARCHAR
|
Maximum size is 4,096 bytes
|
|
VARCHAR2
|
Maximum size is 4,096 bytes
|
