Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export data to BLOB (csv)

user178732Apr 21 2011 — edited Apr 27 2011
Hi,

I need to export data from few tables into BLOB (file in blob might have format of csv). After that I insert this blob into table in Db.

I got this data for export saved in record collections. CSV might be in win1250 endcoding and has dos/windows line end (CRLF).

Could you help me with it? Has anybody any tutorial for this?

CSV should be like this:
COLUMN1|COLUMN2|COLUMN3|COLUMN4|COLUMN5|... -- first line
DATA1a|DATA2a|DATA3a|... -- second
DATA1b|DATA2b|DATA3b|... -- third

Thx

J.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2011
Added on Apr 21 2011
17 comments
7,045 views