Running a Windows batch file based on ROWCOUNT of a table

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

Oracle LazyDBA home page