Differences between BLOB and CLOB in Oracle

Differences between BLOB and CLOB in Oracle

Q

What Are the Differences between BLOB and CLOB in Oracle?

✍: FYIcenter.com

A

The main differences between BLOB and CLOB are:

BLOB stores values as LOB (Large OBject) in bitstreams.
CLOB stores values as LOB (Large OBject) in character steams.

⇒ ANSI Data Types in Oracle

⇐ Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle

⇑ Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2020-04-14, 3860🔥, 0💬

Popular Posts:

Difference between B...

What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both b...

Download Oracle Data...

How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...

sys.procedures - Lis...

How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...

DEFAULT - Providing ...

How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...

Formatting Time Zone...

How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...