hi sulatn,
thanks .i got the point .but if we use aggregate function in hte select
statemwnt no_data_found exception
will not raise.thats i am looking for the solution . how to find out the
select statement not returning any row.instead of count i used max also.
-----Original Message-----
From: Sultan <ssyed_at_fine.co.ae>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Tuesday, July 18, 2000 7:46 AM
Subject: Re: sql%found problem
>HAI all,
>
>The problem not with SQL%found ,problem with count function.
>
>If you use count function definitely it will return value Zero or more than
>zero.
>It means SQL Stmt executed successfully and returning rows also,so It will
>never go to 'No' section in your coding .
>
>By the way for your information
>If you used Count funtion in SQL Stmt You no need to define Exception WHEN
>NO_DATA_FOUND since the count function never return 'no rows';
>
>
>Regards.
>SUL.
>
>
>----- Original Message -----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Sent: Tuesday, July 18, 2000 06:35 AM
>
>
>> Select count statement always returns a number whether there exists rows
>in the table or not.
>>
>> If there are no rows the outcome is 1 row with count as 0.
>> If there are some rows in the table output is 1 row with count of Number
>of rows.
>> As always there is a row returned SQl %found is always TRUE
>> So as per ur logic, it will always go to YES part...
>>
>> Saji
>>
>> ---------------------------------------- Message
>History ----------------------------------------
>>
>>
>>
>> Please respond to ORACLE-L_at_fatcity.com
>>
>> To: ORACLE-L_at_fatcity.com
>> cc:
>>
>>
>>
>> hi all,
>> i had a problem over this query.could u tell me what is wrong in that
>query.
>> ========
>> declare
>> v number(10);
>> begin
>> select count(name) into v from str;
>> if sql%found then
>> dbms_output.put_line('yes '||v);
>> else
>> dbms_output.put_line('no '||v);
>> end if;
>> end;
>> it displays only "yes'' even though the table contins or not contain
any
>rows.
>> could u tellme what went wrong.
>> paul
>>
>>
>>
>>
>> --
>> Author:
>> INET: saji.rajp_at_db.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>
>--
>Author: Sultan
> INET: ssyed_at_fine.co.ae
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
Received on Tue Jul 18 2000 - 11:49:18 CDT
