Re: Returned two values from a case statement?
Brent,
If I understand query ...
SELECT *
FROM table
WHERE otherfield=3
OR (otherfield=1 AND tablefield IN (0,8));
why not PREPARE the query string uo to IN(...), CONCAT a string of the IN(...) expression, then execute the prepared statement?
Peter
Subject
Written By
Posted
December 22, 2005 07:37PM
Re: Returned two values from a case statement?
December 23, 2005 11:59AM
December 23, 2005 02:38PM
December 23, 2005 08:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.