shell script with sql

[Unix or Linux?]

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!

[Sandman!]

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

thanks!

[Unix or Linux?]

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.

[Patrick Wallek · Accepted solution]

Try this:

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

[Unix or Linux?]

That did it. Thanks