Create a sql file

test.sql
--------
declare
begin
your sql statment
end;
/

create a windows batch file
run.bat
-------
sqlplus scott/[Email Address Removed] @c:\test.sql

Hope this helps !!!

Kishore


-----Original Message-----
From: Rajesh_Puneyani
[mailto:oracledba-ezmlmshield-x90536436.[Email address protected]
Sent: Thursday, June 03, 2004 2:50 AM
To: LazyDBA.com Discussion
Subject: Running a Windows batch file based on ROWCOUNT of a table


> Hi all,
>
> If I want to run a windows batch file based on the rowcount <> 0 of a
> table then how should I do that ?
> IF I use a PL/SQL block to SELECT and TEST rowcount then I can not use
> HOST command to call batch file.
>
> On the other hand If I don't use PL/SQL then I can not test rowcount <>0 .
>
> Pls. advise
> Thanx


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
****************************************************************************
This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.
****************************************************************************

Oracle LazyDBA home page