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!

Loading .csv file file to database

987536Feb 5 2015 — edited Feb 6 2015

Hi Gurus,

I have a requirement  to read the file from local system and stores it in the database table (if validation allows to save).

File format is .csv.

File can't be uploaded through oracle forms.

A CC job which accepts local file name and file path as a input , through which we need to load the file into the database for processing.

File can be store intermediately in Unix server also.

Please share your views, how to do it.

Thanks in advance,

karthik M

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2015
Added on Feb 5 2015
13 comments
7,227 views