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!

ASCII FILE type

Ric79Sep 3 2012 — edited Sep 3 2012
Hi all,
I need to PLSQL parse this kind of file:
A      B      C
1      2      3
E      F
2      3
2      13

1      2      djkd
E      F
2      13
In my previous PLSQL code version I used UTL_FILE.GET_LINE. The extracted file row is inserted in a PLSQL varchar2 collection, and then parsed.

In this new version I would like to store the file as CLOB in a column of an Oracle Table. Unfortunately, it was quite difficult to read the CLOB Data newline by newline.

What is the best approach? I cannot use the external table. Is there another approach?
Riccardo
This post has been answered by Solomon Yakobson on Sep 3 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2012
Added on Sep 3 2012
14 comments
374 views