Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle Data Types - CLOB

Versions: Oracle 11g, 10g, 9i and 8i

Oracle - CLOB
Syntax CLOB
Data Variable-length character data (character large object), single-byte and multibyte character sets
Range 4G
Character Set Database default
Transactions BLOB objects have full transactional support, any changes can be committed or rolled back
Internals Data up to 4000 bytes can be stored inline if you enable ENABLE STORAGE IN ROW option (this is the default).
Data greater than 4000 bytes are always stored externally and you can specify different tablespace and storage characteristics
Standards Oracle Extension

Oracle CLOB - Equivalents in Other Databases

Database Data Type and Conversion
SQL Server VARCHAR(max) or TEXT, 2G
PostgreSQL TEXT, 1G
Sybase ASE TEXT, 2G
Informix TEXT, 2G, CLOB, 4T
HP Neoview VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)
Ingres TEXT(n), 1 ⇐ n ⇐ 32000; LONG VARCHAR, 2G

Related Data Types in Oracle

Data Types
Fixed-length Character Data CHAR(n) NCHAR(n)
Variable-length Character Data VARCHAR2(n) NVARCHAR2(n)
Character Large Objects NCLOB LONG

All Data Types

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.