PLSQL Data Types Size

Different Maximum Sizes

The SQL data types listed in the list have different maximum sizes in PL/SQL and SQL.

 Data Types with Different Maximum Sizes in PL/SQL and SQL

Data Type Maximum Size in PL/SQL Maximum Size in SQL
CHARFoot 1  32,767 bytes 2,000 bytes
NCHARFootref 1 32,767 bytes 2,000 bytes
RAWFootref 1 32,767 bytes 2,000 bytes
VARCHAR2Footref 1 32,767 bytes 4,000 bytes
NVARCHAR2Footref 1 32,767 bytes 4,000 bytes
LONGFoot 2  32,760 bytes 2 gigabytes (GB) – 1
LONG RAWFootref 2 32,760 bytes 2 GB
BLOB 128 terabytes (TB) (4 GB – 1) * database_block_size
CLOB 128 TB (4 GB – 1) * database_block_size
NCLOB 128 TB (4 GB – 1) * database_block_size
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: