is it possible to use sqlplus
to read a file and put the content to a blob column of a table?
the file i want to insert is located at my local machine.
if so , how?
Printable View
is it possible to use sqlplus
to read a file and put the content to a blob column of a table?
the file i want to insert is located at my local machine.
if so , how?
no
It is possible to read the contents of a binary file into a BLOB using PL/SQL.Quote:
Originally posted by pando
no
dbms_lobs
but not in sql plus
That's correct. Not in SQL*PlusQuote:
Originally posted by pando
dbms_lobs
but not in sql plus
use sqlloader ...
Sam
maybe you could supply an example control file of how to load blobs via sqlldr...Quote:
Originally posted by sambavan
use sqlloader ...
A sample control file for loading blob data:
load data
infile 'test_lob.dat'
append into table test_lob
fields terminated by ','
(id , name, external_filename FILLER,
name_lob LOBFILE(external_filename) TERMINATED BY EOF
)
The data in test_lob.dat has
1,'Tamilselvan',tamil.jpg
2,'Kannan',Kannan.jpg