The SQL data types listed in the following table have different maximum sizes in PL/SQL and SQL.
| Data Type | Maximum Size in PL/SQL | Maximum Size in SQL |
|---|---|---|
| CHAR1 | 32,767 bytes | 2,000 bytes |
| NCHAR1 | 32,767 bytes | 2,000 bytes |
| RAW1 | 32,767 bytes | 2,000 bytes |
| VARCHAR21 | 32,767 bytes | 4,000 bytes |
| NVARCHAR21 | 32,767 bytes | 4,000 bytes |
| LONG2 | 32,760 bytes | 2 gigabytes (GB) - 1 |
| LONG RAW2 | 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 |