Home » SQL & PL/SQL » Client Tools » Execute multiple SQL files in .bat file (Windows XP, Oracle 10g)
Execute multiple SQL files in .bat file [message #571552] Tue, 27 November 2012 01:25 Go to next message
new_oracle2011
Messages: 165
Registered: March 2011
Location: Qatar
Senior Member
Is it possible to execute multiple sql files in one .bat file?

for single sql file it is working properly.

.bat file
-------------------------------
sqlplus /nolog @ c:\test01.sql
Re: Execute multiple SQL files in .bat file [message #571553 is a reply to message #571552] Tue, 27 November 2012 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 57607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The command syntax does not allow naming several scripts.
Create a script that calls all scripts you want to execute.

Regards
Michel
Re: Execute multiple SQL files in .bat file [message #571555 is a reply to message #571553] Tue, 27 November 2012 01:37 Go to previous messageGo to next message
new_oracle2011
Messages: 165
Registered: March 2011
Location: Qatar
Senior Member
Can you tell me the command syntax which allows several scripts?
Re: Execute multiple SQL files in .bat file [message #571558 is a reply to message #571555] Tue, 27 November 2012 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 57607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None. I thought it was clear in my post.

Regards
Michel
Re: Execute multiple SQL files in .bat file [message #571563 is a reply to message #571558] Tue, 27 November 2012 02:13 Go to previous messageGo to next message
new_oracle2011
Messages: 165
Registered: March 2011
Location: Qatar
Senior Member
Michel Cadot wrote on Tue, 27 November 2012 10:39
None. I thought it was clear in my post.

Regards
Michel


Finally, the problem is solved and the solution is: http://shahiddba.blogspot.com/2012/05/how-to-run-multiple-sql-file-from-dos.html

In future, please try to explain with example. Everyone is not intelligent like you...
Re: Execute multiple SQL files in .bat file [message #571564 is a reply to message #571563] Tue, 27 November 2012 02:18 Go to previous message
Michel Cadot
Messages: 57607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In future, try to explain your problem with example. Everyone is not farseeing like you...

Regards
Michel
Previous Topic: Dynamically Spool data in a PL/SQL block
Next Topic: SQL Navigator site message
Goto Forum:
  


Current Time: Thu Apr 17 15:14:09 CDT 2014

Total time taken to generate the page: 0.11359 seconds