Skip navigation.

dwaipayan19861's blog

Playing with Oracle Lobs

dwaipayan19861's picture

LOBs deal with unstructured data, the ones which are the most difficult to store and retrieve in a relational database.

In this article, I am going to discuss extensively and manipulate the ORACLE

* LOBs that are stored in the database itself like BLOB,CLOB,NCLOB ,and

* LOBs like BFILE which are Stored outside the database as Operating System files.

First let us create a directory :

create or replace directory my_dir as 'D:\pics';
Directory created.

BFILE:
BFILEs act as a pointer and store the location of the external OS files in database tables.

1.