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';
BFILEs act as a pointer and store the location of the external OS files in database tables.