Re: Re: read BLOB / insert into table in plsql ?

From: Prem Khanna J <premj_at_rediffmail.com>
Date: 15 Jul 2004 03:11:48 -0000
Message-ID: <20040715031148.21990.qmail@webmail10.rediffmail.com>

> Janne Wrote :
>insert into URTAB1(the_blob ) select MYCOL1 from MYTAB1 where ....
thanx Janne.BUT the source is a blob column (with csv file in it) and target is a list of columns which match the content of csv file.

if a line in source csv file (in BLOB column) looks like this:

---

1,SCOTT
2,KING then the target table structure will look like

---

EMPNO INT,
ENAME VARCHAR2 the csv file (in BLOB column) needs to be read line by line and inserted into target table as records.No BLOB in target table.

>On Wed, 14 Jul 2004 Raj Jamadagni wrote :
>dbms_lob has all that you need to know and use.

thanx for ur input Raj . i was thinking about various options to do it.

Regards,
Prem

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 14 2004 - 22:08:47 CDT