Re: Hi

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sun, 22 Dec 2002 19:47:46 GMT
Message-ID: <Xns92EC78321AB5FSunnySD@68.6.19.6>

"Oradba Linux" <oradba_linux_at_attbi.com> wrote in news:fjmN9.67406$qF3.4863_at_sccrnsc04:

> I need to write a shell script that would call a sql script . While
> this sql script is running i need to run another SQL in another
> session continuously .
> test.ksh would call test.sql which would run for about 10 -20 minutes
> . I would like to call test1.sql ( which basically would be like
> "select * from dual" ) and spool to a log file .
> Any clues to do this will help .
>
> Thanks
>

I surmise that you know neither Oracle nor Linux, other than being able to spell each of them.

sqlplus << EOF
@test1
exit
EOF HTH & YMMV! Received on Sun Dec 22 2002 - 13:47:46 CST