-
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?
guru is on the way!!!!
-
-
Originally posted by pando
no
It is possible to read the contents of a binary file into a BLOB using PL/SQL.
-
dbms_lobs
but not in sql plus
-
Originally posted by pando
dbms_lobs
but not in sql plus
That's correct. Not in SQL*Plus
-
Thanx
Sam
Life is a journey, not a destination!
-
Originally posted by sambavan
use sqlloader ...
maybe you could supply an example control file of how to load blobs via sqlldr...
Jeff Hunter
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|