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