![oracle11g - Having a case statement in where clause along with constant value in Oracle causes wrong results - Stack Overflow oracle11g - Having a case statement in where clause along with constant value in Oracle causes wrong results - Stack Overflow](https://i.stack.imgur.com/VZiFn.png)
oracle11g - Having a case statement in where clause along with constant value in Oracle causes wrong results - Stack Overflow
![oracle11g - Having a case statement in where clause along with constant value in Oracle causes wrong results - Stack Overflow oracle11g - Having a case statement in where clause along with constant value in Oracle causes wrong results - Stack Overflow](https://i.stack.imgur.com/NjptU.png)
oracle11g - Having a case statement in where clause along with constant value in Oracle causes wrong results - Stack Overflow
![How to Write Case Statement in WHERE Clause? - Interview Question of the Week #127 - SQL Authority with Pinal Dave How to Write Case Statement in WHERE Clause? - Interview Question of the Week #127 - SQL Authority with Pinal Dave](https://i0.wp.com/blog.sqlauthority.com/wp-content/uploads/2016/06/caseorderby.jpg?resize=350%2C200&ssl=1)