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!

Reading data from CSV file using utl_file

santhosh.shivaramApr 9 2009 — edited Apr 9 2009
Hi,
Can anyone guide me how to load data from CSV file into oracle tables using utl_file.

My requirement is like

Client is sending me a excel in which top 5 rows having some details about the excel sheet which i need to skip and the actual header nd data starts from 6th row.

So i want to import the data from 6th row ignoring the top 5 rows.

Can anyone help me with this.
Many Thanks,
Santhosh.S
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2009
Added on Apr 9 2009
11 comments
12,293 views