Re: Did the query return any rows

From: Randy Harris <randy_at_SpamFree.com>
Date: Mon, 23 May 2005 00:32:54 GMT
Message-ID: <Ww9ke.440$uu.371@newssvr33.news.prodigy.com>

"absinth" <absinth_at_gmail.com> wrote in message news:1116807160.680616.275510_at_o13g2000cwo.googlegroups.com...
> Consider:
>
>
> SQL> select row_id from CX_LOCK;
>
> ROW_ID
> ---------------
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
> 11
>
> ROW_ID
> ---------------
> 12
>
> 12 rows selected.
>
> SQL> select row_id from CX_LOCK where ROW_ID='abc';
>
> no rows selected

But how can I determine in the script whether any rows were returned? Is there some way to "capture" that no rows selected message? Received on Sun May 22 2005 - 19:32:54 CDT