Re: Dynamic filter clause
Posted by:
Manish G
Date: September 14, 2015 11:15PM
Thanks for the reply Peter.. It was returning incorrect rows..
I have a solution (still being verified though). It;s on the same logic that I posted earlier but I am checking for NULL first..
eg:
(t.minPrice IS NULL OR (t.minPrice IS NOT NULL and s.Price <= t.minPrice ) )
Subject
Written By
Posted
September 13, 2015 10:50PM
September 14, 2015 12:39PM
Re: Dynamic filter clause
September 14, 2015 11: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.