Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Oracle Database Express Edition (XE)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jun 7, 2013 6:03 PM by
HOW TO READ MULTIPLE FILES FROM DIRECTORY
Jun 7, 2013 5:10 PM
i have a directory with 100 .sql insert scripts.i want to read all .sql files from directory and execute the insert script automatically.
This content has been marked as final.
Show 1 reply
Re: HOW TO READ MULTIPLE FILES FROM DIRECTORY
Jun 7, 2013 6:03 PM
in response to
Let's suppose you have 3 files: "first.sql", "second.sql" and "third.sql". Create a file named "all.sql" in the same directory, containing this:
@@first.sql @@second.sql @@third.sql