UTL_FILE Package (Retrieving Flat File data and inserting into Oracle DB Tables)

Hi,

I am looking for some code. Pls help me if you can.

Retrieving data from Flat Files (CSV) and inserting into Oracle 9i Data Base using UTL_FILE Package.

Example Data : 123, abc

This data should be inserted in oracle data base table as seperate fields (code, name)


Thanks

Hi,
please use UTL_FILE utility from oracle .
use utl_file.fopen the file from the directory where you saved yours.
check for the delimeter in the file.
use oracle instr and substr to segerate the values.
and then you can easily insert into the tables.