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 get the file name from directory

sanSep 27 2010 — edited Sep 27 2010

Hi,

I have a directory called test inside i have only one .txt file. i dont know that file name.

Is it possible get the file name using PL/SQl code. ???

Using that .txt file i have to create a dynamic table.

If i have use *.txt also not working

Anyone suggest me its possible to do or not????

Cheers,
Shan

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2010

Added on Sep 27 2010

17 comments

5,686 views