OraFAQ Forum: Client Tools » Execute multiple SQL files in .bat file

Home » SQL & PL/SQL » Client Tools » Execute multiple SQL files in .bat file (Windows XP, Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Execute multiple SQL files in .bat file [message #571552]

Tue, 27 November 2012 01:25

new_oracle2011
Messages: 174
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

Report message to a moderator

Re: Execute multiple SQL files in .bat file [message #571553 is a reply to message #571552]

Tue, 27 November 2012 01:27

Michel Cadot
Messages: 67639
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

Report message to a moderator

Re: Execute multiple SQL files in .bat file [message #571555 is a reply to message #571553]

Tue, 27 November 2012 01:37

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

Can you tell me the command syntax which allows several scripts?

Report message to a moderator

Re: Execute multiple SQL files in .bat file [message #571558 is a reply to message #571555]

Tue, 27 November 2012 01:39

Michel Cadot
Messages: 67639
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

None. I thought it was clear in my post.

Regards
Michel

Report message to a moderator

Re: Execute multiple SQL files in .bat file [message #571563 is a reply to message #571558]

Tue, 27 November 2012 02:13

new_oracle2011
Messages: 174
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...

Report message to a moderator

Re: Execute multiple SQL files in .bat file [message #571564 is a reply to message #571563]

Tue, 27 November 2012 02:18

Michel Cadot
Messages: 67639
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 15 12:53:00 CST 2021