What is the difference between CLOB and BFile in Oracle Database

The Oracle BFile type, is used to store unstructured binary data outside of the database in the operating system. BFiles are read-only and only support random-reads.

CLOB type is stored in the database using two byte code character set. Unlike BFile, CLOB support sequential access and can be modified.

Comments

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle