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

Table 3-1 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
LONGRAWFootref 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

^{Footnote 1} When specifying the maximum size of a value of this data type in PL/SQL, use an integer literal (not a constant or variable) whose value is in the range from 1 through 32,767.

^{Footnote 2} Supported only for backward compatibility with existing applications.

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/datatypes.htm#LNPLS314

转载于:https://blog.51cto.com/guerrilla/1351115