Re: Shel Script

From: Martin Bronstein <Martin.Bronstein_at_trw.com>
Date: 1997/07/25
Message-ID: <33D8C5A8.32DA@trw.com>#1/1

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".

SQLPLUS username/password @comfile
where comfile is a file of your SQL*Plus commands.

Martin Bronstein Received on Fri Jul 25 1997 - 00:00:00 CDT