Skip to Main Content
Forums

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!

Count files in a dirctory using plsql

RedeAug 18 2010 — edited Aug 19 2010
Hi ,

Currently i am using a shell script that counts the number of files in unix level directory that had xml files and load to the table as CLOB using the sql loader.

Now i want to use plsql l to count files and then load using insert the script.I am able to use insert statement but not have any idea to count files at unix level using plsql.

Please give me some ideas.

Thanks in Advance.
Rede
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2010
Added on Aug 18 2010
8 comments
4,717 views