Re: Simple Select Return Record

  • From: Vlad Sadilovskiy <vlovsky@xxxxxxxxx>
  • To: jacintakean@xxxxxxxxx
  • Date: Thu, 9 Jun 2005 00:26:26 -0400

try:

select count(*)=20
from dual
where exists (select null from employee_tbl where employeeid=3D5);

- Vlad

On 6/8/05, Kean Jacinta <jacintakean@xxxxxxxxx> wrote:
> hi,
>=20
> Trying to query a select statement to check if return
> record existed or not existed.
>=20
> select employeeid from employee_tbl
> where employeeid=3D5;
>=20
> If i type this in SQL*PLus, or sql worksheet , i can
> easily know if the record is found or record not
> existed in the table.Becoz it will display result if
> found .
>=20
> How to know if a record is found or not found in
> programming code.I need the sql statement to return 0
> if not found and return 1 if found.
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l

Other related posts: