Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: if-then-else in SELECT
You can do something like:
SELECT NAME, CASE WHEN NAME = 'AIMEE GORE' THEN 1 ELSE 0 END EXACT_MATCH
FROM AG_CLIENT
WHERE NAME = 'AIMEE GORE' OR NAME IN ('AIMEE','AIMEE GORE')
ORDER BY 2 DESC
Your calling program can check the value in exact_match. If 1, then no
reason to fetch any more records (unless you expect duplicates), otherwise
fetch all remaining records.
HTH,
-----Original Message-----
From: elain he [mailto:elainhe_at_hotmail.com]
Sent: Wednesday, March 03, 2004 1:33 PM
To: oracle-l_at_freelists.org
Subject: if-then-else in SELECT
Hi,
I would like to retrieve records based on the following if-then-else
criteria.
for eg.
retrieve all empolyee names='AIMEE GORE'
if there is no exact match,
retrieve employee names='AIMEE' or employee_name='GORE'
How can I write the SQL?
DB - 8i
thanks.
elain
"This information in this e-mail is intended solely for the addressee and may contain information which is confidential or privileged. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy, retransmit, disseminate, or otherwise use the information. Also, please notify the sender that you have received this e-mail in error, and delete the copy you received."
![]() |
![]() |