Re: Q: To check a record's existence in a table, FAST!

In <335996ab.33078892_at_news.netvigator.com> budlo_at_netvigator.com (Bud Lo) writes:
>Hi all,
 

>My requirement is very simple.
 

>To check a record's existence in a table. ( i am using Oracle 7)
 

>Obviously, this SQL will do:
 

>select count(*) into nCount from table where ColA='ABC';

I have a related but a bit more difficult task: I want to distinguish between

- 0 rows
- 1 row
- >1 row

Is there a better way for this then

   select count(a) into iCount from b where c; and then checking iCount?
?

Thanks in advance

        Martin

-- 
               Martin Schr"oder, MS_at_Dream.HB.North.DE
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.3ia

mQENAzNGllYAAAEIANjfO7elGs1++9PC0W5UPP8QZeIGKJUPuEhurLjagof0gPnI
KiZQwZf467l2WdX/ZDAk93Q73q3zNtQBTRxF/rvH+yvnx0QFgHtseixqIMzY3M1w
3EI7qjb3U8G2hHCgRXXODiaBu1y0cSAgCl+bKmSL6FjbF13Ho7coX2N9G4zGJ3hq
w/yaypTq9X8NFSznt2cd0wusi1IUDqd62f4oQPFAR0z/cqKFIrObHL83oCXuMc/6
+5YkZtyN/ZLYynDFCqZH25wfp6dr44UxAk2Uth2nRHEpvluDvTGZWrHpeLhVuUNN
LGm0zqb5t1EJAwFZZ1uIpN7g48/6Ozt6/67N/oUABRO0J01hcnRpbiBTY2hyb2Vk
ZXIgPE1TQERyZWFtLkhCLk5vcnRoLkRFPokBFQMFEDNGllY7O3r/rs3+hQEBFGUH
/0Y3uqegTJ6xSj1bn7QgyVD1ZfTOjWNsZgif3V/EQZAi3QBm1Ne5QrB1MyXHN5nt
+qXllBrJN2q5jv5yjbV+JdQc/o+2CiPTdUUrzCLHE8CC1c22mOQvxDGilFNzpCmq
SRTyKTX4BJRB4prSkx1NBaALqVCT5qamDclbJCazkB76vYkPnVbwvznlllFHPdVp
9QdbT50Hli/qYPkI0gxBxi/B4KNpAJQ6EswOLK3thMrfFO3RWbCl9bPE+nt+gJ8E
nqQXjIwdLYg2g6MZIuX7FtAdl4WO2pYSKjsEsGTh4aca+5hLWKoKyaV11ObLOdO5
afFgU88RIigZJYIzwRJgCtw=
=67Ih
-----END PGP PUBLIC KEY BLOCK-----