Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle Data Types - BLOB

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

Oracle - BLOB
Syntax BLOB
Data Variable-length binary data (binary large object)
Range 4G
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 BLOB - Equivalents in Other Databases

Database Data Type and Conversion
SQL Server VARBINARY(max), 2G, IMAGE, 2G
PostgreSQL BYTEA, 2G
Sybase ASE IMAGE, 2G
Informix BYTE, 2G, BLOB, 2T

Related Data Types in Oracle

Data Types
Variable-length binary data RAW LONG RAW

All Data Types

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