The SQL Group By Clause
This is the written version of a lesson from my SQL Course, in which I introduce students to the awesome and very commonly used SQL GROUP BY clause. If you want to follow along, here is the script you can… Continue Reading
The Oracle Multitenant Architecture
This is the written version of a lesson from my SQL Course, in which I introduce students to the Multitenant Architecture. The MULTITENANT architecture was introduced in version 12c and included for the first time in an express edition in… Continue Reading
The FIRST and LAST functions in Oracle SQL
This is the written version of a lesson from my SQL Course, in which I show how to use the FIRST and LAST functions. Like some other functions you probably know, these functions can be used either as aggregate functions… Continue Reading
Pairwise Comparisons With Subqueries in Oracle SQL
I recently received a question about Pairwise Subqueries from one of the students in my SQL course, and I thought it would be a good idea to make my answer a blog post, since I did a couple of Google… Continue Reading
How to Change Oracle SQL Developer Language
I needed to change SQL Developer language, because today I installed it on a machine whose operating system is Windows 8 in Spanish, and SQL Developer got installed in Spanish too :-/ Even though Spanish is my first language, I… Continue Reading
Count(*) Vs Count(1) Again?
I decided to write this article because the question about COUNT(*) Vs COUNT(1) keeps being asked, and I usually find myself explaining my answer again and again and/or looking for links to someone else’s articles that can help support my… Continue Reading
OTN Appreciation Day : The Power of Oracle SQL
I’m writing this post as a contribution to the OTN appreciation day because I think Tim Hall’s idea was awesome. If I have to choose the feature I like and enjoy the most, it has to be the power of… Continue Reading
Prioritizing Rows: The Ranking Functions
Ranking functions are some of the most commonly used analytic functions, and although the “ranking” category can quickly make you think about Top-N queries, that is actually not the only type of problems you can solve with them. In this… Continue Reading
The awesome Pivot and Unpivot Features in Oracle SQL
I decided to write about the Pivot and Unpivot clauses, because I find them very useful and powerful. In this article I will try to explain how they are used and show you some examples of the things you can… Continue Reading
Understanding Analytic Functions
Analytic functions in Oracle SQL are very useful and are utilized by many people, but sometimes without completely understanding how they work or what data they operate on. This article does not focus on a specific function, but on analytic… Continue Reading