topic Re: shell script with sql in Operating System - Linux

shell script with sql

Unix or Linux? — Thu, 12 Oct 2006 11:00:06 GMT

I would like to issue some sql statements from within a shell script. Not sure how to go about it. Basically the shell script connects to the schema on the database and then should proceed with the select statements. But instead it just connects and stays with the SQL prompt. Hope it makes sense!

Re: shell script with sql

Sandman! — Thu, 12 Oct 2006 11:01:49 GMT

Could you post your script here so it can be looked at.

thanks!

Re: shell script with sql

Unix or Linux? — Thu, 12 Oct 2006 11:07:10 GMT

ORACLE_SID="EM"; export ORACLE_SID
sqlplus user1/user1
select * from table1

It connects user1 to the database, but it does not run the select statement.

Re: shell script with sql

Patrick Wallek — Thu, 12 Oct 2006 11:09:48 GMT

Try this:

ORACLE_SID="EM"; export ORACLE_SID
sqlplus user1/user1 << EOF
select * from table1
exit
EOF

Re: shell script with sql

Unix or Linux? — Thu, 12 Oct 2006 11:12:21 GMT

That did it. Thanks