Inserting into Clob and Blob columns
561456Mar 23 2007 — edited Mar 29 2007I have no prior knowledge in LOBS.
I have a table like this :
create table t
(id number,
name varchar2(20),
info clob,
img blob,
more varchar2(250),
flg char
);
I am having the data for all columns in a excel sheet. Data for the image for "img" column exists as jpgs and gifs (each in both file type). Excel, jpg and gif are on my hard disk.
Please tell me how to load data into the table. I have to load around 25 rows.
If required I can put the data for clob column in seperate text files (if its easier to load that way). Help me!!