Re: count row function

Sandy,

If the client number '02' doesn't exist in table client then the query you mentioned

>select count(*) from client where client.number='02';

will return 0. If the client exists then it will return the number of occurrence of this client in the table client.

Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com

Sandy napisa³(a) w wiadomo¶ci:
<1659ac50.4d8c8fed_at_usw-ex0110-076.remarq.com>...
>hi,
>
>I want to know if a client exists in a function. For this I
>have made a function with a select count... that returns
>the number of rows of the query : if he exists 1( normally)
>and if not 0. But doesn't work correctly. What happens
>when for example a client number '02' doesn't exist in the
>table client and we do the query :
>
>select count(*) from client where client.number='02';
>
>thanks
>
>sandy
>
>
>* Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Tue Sep 05 2000 - 08:28:58 CEST