November 2015 - Standout-dev

Top-N queries in Oracle SQL

Posted on November 24, 2015 by Carlos

I decided to write about Top-N queries today because even though there are lots of articles and documentation about the correct way to do it in Oracle out there, I have seen this question asked on different forums, and to… Continue Reading →

CASE expressions in Oracle SQL

Posted on November 10, 2015 by Carlos

CASE expressions are the standard way to implement IF … THEN … ELSE logic in SQL statements. Oracle provides the DECODE function, which does something similar and is widely used by Oracle developers, but CASE expressions are actually more flexible… Continue Reading →