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!

sql loader script

692864Apr 28 2009 — edited Jun 15 2010

hi all i require a sql loader script

i have some files that i will have to load to oracle database 11g... i dont know the number of files that will fall on the directory daily

how do i do this. ?

my requirement is in_file parameter in the control file should be dynamically populated with the file names and all the files should be processed ... the structure and columns in all the files are same.

plz let me know if you have code for this.

regards
raj

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2010

Added on Apr 28 2009

31 comments

8,209 views