Showing posts with label CASE expression. Show all posts
Showing posts with label CASE expression. Show all posts

Thursday, September 24, 2009

Using CASE in WHERE clause

After much searching, I found that yes, you can use CASE expressions in the WHERE clause of a PL/SQL SELECT statement. The article titled case expressions and statements in oracle 9i provides excellent examples and even explains the impact on query plans.