Re: Shel Script

Kevin Kelleher wrote:
>
> On Tue, 15 Jul 1997 22:04:45 -0400, terryg8 <trg_at_ibm.net> wrote:
>
> >RISHI ANAND wrote:
> >>
> >> Hello All,
> >>
> >> Just had a question, as to how could we write a shell script in UNIX, if
> >> I wanted to execute SQL commands by simply running them within the shell
> >> script?

Another solution is :

sqlplus <connect string> <<EOF
spool $1
select .... from ...
 where ...
spool off
EOF sqlplus will read all statements between <<EOF and EOF

Leo

Leo Put
Vlaamse UitgeversMaatschappij Belgium
lp2014_at_vum.be Received on Thu Jul 17 1997 - 00:00:00 CDT