| Read a directory! [message #39304] |
Thu, 04 July 2002 10:43  |
Leonard
Messages: 9
Registered: March 2000
|
Junior Member |
|
|
Hi
Is there a way to loop thru a directory and get all the filenames into an oracle table ???? If anyone knows how to have this done, pls let me know
Leonard
|
|
|
|
| Re: Read a directory! [message #39305 is a reply to message #39304] |
Thu, 04 July 2002 11:45  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
USING utl_FILE, you can execute host commands like
dir/b *. sql > allfilenames.txt.
then, you can read allfilenames.txt line by line into your table using the same utl_file.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
