Re: Parameter passing from SQLPLUS to NT Batch

On Mon, 15 Apr 2002 22:03:57 +0100, "TC3 Racer" <gordonchapman_at_hotmail.com> wrote:

Just spool your output and use the SQLPLUS host command to run a script that reads the output file.

spool output.file
select count(*)
spool off

!command.bat

>I want to use an NT batch file, running every hour, to do a
>
>Select count(*) from tablename.
>
>I then want to pass the result out and if its zero, have another batch file
>that does various things
>
>How do I get the the value out of the sql script
>
>Thanks in advance
>
>GC
>
>
>
>
Received on Mon Apr 15 2002 - 16:41:02 CDT