Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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