Re: Re: read BLOB / insert into table in plsql ?
- From: "Prem Khanna J" <premj@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: 15 Jul 2004 03:11:48 -0000
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
