Standout-dev
Oracle SQL Tips, Tricks and Hacks to help Developers stand out.
Menu Close
  • Blog
  • Video Courses
  • Oracle SQL Tutorial

Author: Carlos

3

How Important is to Format your SQL Code?

Posted on May 25, 2021 by Carlos

A few days ago, I was quickly scanning my Twitter feed, and I saw a poll from a relatively popular Twitter account, asking people how they format their SQL code or how they apply a specific SQL code format. After… Continue Reading →

Best Practices, SQL, SQL Developer
2

The SQL Group By Clause

Posted on March 12, 2019 by Carlos

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 →

Basics, Functions, SQL aggregate, aggregate functions, aggregates, GROUP BY, GROUP BY clause, SQL
2

The Oracle Multitenant Architecture

Posted on March 8, 2019 by Carlos

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 →

Oracle Database architecture, CDB, container, database, multitenant, Oracle, PDB, pluggable, root, seed
1

The FIRST and LAST functions in Oracle SQL

Posted on September 27, 2018 by Carlos

This is the written version of a lesson from The Ultimate Oracle SQL Course, in which I show how to use the Oracle FIRST and LAST functions. Like some other functions you probably know, these functions can be used either… Continue Reading →

Functions, SQL aggregate, analytic, FIRST, function, functions, LAST, Oracle, SQL
3

Pairwise Comparisons With Subqueries in Oracle SQL

Posted on September 11, 2018 by Carlos

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 →

SQL Oracle, SQL, Subquery
37

How to Change Oracle SQL Developer Language

Posted on April 18, 2018 by Carlos

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 →

SQL Developer English, language, Oracle, SQL Developer, user interface
39

Count(*) Vs Count(1) Again?

Posted on January 31, 2017 by Carlos

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 →

SQL, Tuning 10053, count, count(*) vs count(1), COUNT(1), count(1) vs count(*) oracle, optimizer, query, Trace, Transformation

OTN Appreciation Day : The Power of Oracle SQL

Posted on October 11, 2016 by Carlos

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 →

Functions, SQL features, OTN
4

Prioritizing Rows: The Ranking Functions

Posted on August 25, 2016 by Carlos

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 →

Functions, SQL analytic, function, functions, Oracle, prioritize, ranking, SQL, top-n
11

The awesome Pivot and Unpivot Features in Oracle SQL

Posted on June 10, 2016 by Carlos

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 →

SQL columns, convert, Oracle, pivot, rotate, rows, SQL, transpose, unpivot

Post navigation

Older Articles

SQL Best Practices

The Standout-Dev Academy is launching an Oracle SQL Best Practices video course.

If that sounds like something you would be interested in, click the link below to learn more.

Don't want to miss any Oracle SQL tips?

Subscribe to the newsletter to make sure you don't miss any content!

Recent Posts

  • How Important is to Format your SQL Code?
  • The SQL Group By Clause
  • The Oracle Multitenant Architecture
  • The FIRST and LAST functions in Oracle SQL
  • Pairwise Comparisons With Subqueries in Oracle SQL

Categories

  • Basics
  • Best Practices
  • Functions
  • Oracle Database
  • SQL
  • SQL Developer
  • Tuning

Archives

  • May 2021
  • March 2019
  • September 2018
  • April 2018
  • January 2017
  • October 2016
  • August 2016
  • June 2016
  • April 2016
  • January 2016
  • November 2015
  • October 2015
  • September 2015
  • August 2015
© 2025 Standout-dev. All rights reserved.
Hiero by aThemes
Shares