OraFAQ Forum: Unix » help in running multiple queries

Home » Infrastructure » Unix » help in running multiple queries (11g)

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

help in running multiple queries [message #629598]

Thu, 11 December 2014 16:58

sisimoz
Messages: 3
Registered: December 2014
Location: MOZ

Junior Member

Hi,
Sorry if is not the right forum.
I would like to run multiple queries like bellow
file1.sql, file2.sql, filen.sql

Oracle_home=/.../
$Oracle_home/bin/sqlplus user/password@tnsname <<EOF
i=1
while $i<5 do;
@/home/scripts/file$i.sql
i=$(($i+1))
done
exit

So how can do it, help
So i need help in running such queries

Report message to a moderator

[Message index]

		help in running multiple queries By: sisimoz on Thu, 11 December 2014 16:58
		Re: help in running multiple queries By: BlackSwan on Thu, 11 December 2014 22:23
		Re: help in running multiple queries By: sisimoz on Fri, 19 December 2014 08:22
		Re: help in running multiple queries By: Michel Cadot on Fri, 12 December 2014 00:41
		Re: help in running multiple queries By: sisimoz on Fri, 19 December 2014 08:20

Previous Topic:	Telnet 192.168.253.98 5000 gives connection refused
Next Topic:	Shell script - update dates every month

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 10:56:37 CDT 2024