Simple Select Return Record

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Wed, 8 Jun 2005 20:46:09 -0700 (PDT)
Message-ID: <20050609034609.403.qmail@web52905.mail.yahoo.com>

hi,

Trying to query a select statement to check if return record existed or not existed.

select employeeid from employee_tbl
where employeeid=5;

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 .

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.

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 08 2005 - 23:51:10 CDT