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!

How to read the name of .csv file from a particular folder using Oracle.

Karthik.KMay 9 2008 — edited May 9 2008

Gurus,

I have a folder called 'data_dir' in Oracle Server and it contains 10 different .csv files and the name of the each file is being suffixed by date and time(24 hrs format).
First i need to read all the file names then i have to process those files by UTL_FILE to load the data into a relational table.

Is there any mechanism is available in Oracle to read the file names?
(In this case all the 10 different csv file names)
If so, then please help me accomplish this.

Thanks in advance.

Regards,
Venugopal.K

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2008

Added on May 9 2008

2 comments

518 views