Calling sql statement from Unix scripts

[jayjaybigs]

Hello all,

I was just wondering if anyone has a scripts that will let you connect to database from the Unix box, execute your select statemetn, spool the result of the select and exit oracle server.

Tahnks

 

[PHV]

And why not have a look at the FAQ area before posting ?

http://www.tek-tips.com/faqs.cfm?fid=2218

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jayjaybigs]

Hello All,

I am trying to call my simple sql statement from within either unix or perl script. I know this is simple enough.

Here is my effort:

#!/bin/sh

sqlplus RPB/lowrider

@check.sql

exit

However, I am not having any luck. Also, the script is not exiting sqlplus back to unix box

 

[PHV]

Just to know, have you read the FAQ I suggested you ?

 

[jayjaybigs]

Here is the solution I came up with:
#!/bin/sh
sqlplus /nolog <<EOF
connect RPB/lowrider
@check.sql
exit
EOF

Your FAQ dealt with different subject. I just wanted a simple solution!