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, 2114🔥, 0💬

Popular Posts:

CHARINDEX() and SUBS...

How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...

"IF ... ELSE IF ..."...

How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......

AdventureWorksLT - D...

How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...

CREATE INDEX - Creat...

How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...