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