Re: Shel Script

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? (It could be any shell, c, korn,...etc..) I tried using the
> script with "sqlplus/ but it just gets stuck at the sqlplus prompt
> and
> waits for me to input some SQL commands....I think I must be missing
>
> something....any idea...?
>
> Please let me know..
>
> Thanks in advance.
>
> --
> --Rishi
>
> ## Never let your sense of morals prevent you from doing what is
> right. ##
>
> -- Salvor Hardin, "Foundation".

 try:
SQLPLUS user/password <<EOF
SQL statements....
EOF Received on Wed Jul 16 1997 - 00:00:00 CDT