query regarding using external table concept in plsql

Asked Apr 02 '15 at 13:35

Active Feb 14 '17 at 07:37

Viewed 49 times

While using external table one BAD file was generated. BAD file(“abc.bad”) has data like

“E51″,12345,555333,”anbd”,”kksksk”  
E51″,12345233,55333,”anbd”,”kksksk”

How can I insert above data into table in a single column as varchar. currently the default field separator defined in oracle is , and it's inserting only the 1st field.

How to override this default definition to consider entire record and insert into a single column

edited Feb 14 '17 at 07:37

asked Apr 02 '15 at 13:35

y2j

You could insert the file in a column as blob or clob – Typo Apr 05 '15 at 15:45
@Typo . how can i read clob column and insert into a table – y2j Apr 06 '15 at 07:15
Check this: http://geekswithblogs.net/robertphyatt/archive/2010/03/24/write-read-and-update-oracle-clobs-with-plsql.aspx – Typo Apr 06 '15 at 10:24

query regarding using external table concept in plsql

0 Answers0