Oracle SQL Tips, Tricks and Hacks
Everything Oracle SQL
Menu Close
  • Blog
  • Video Courses
  • Oracle SQL Tutorial

Functions

1

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
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 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 →

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

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

Understanding Analytic Functions

Posted on April 17, 2016 by Carlos
analytic functions windowing clause

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 →

Functions, SQL analytic, function, functions, Oracle, partition, SQL, window, windowing
4

The Powerful DECODE Function

Posted on August 25, 2015 by Carlos

Oracle’s DECODE is one of the functions I find more powerful and one that over the years I have used thousands of times to solve several different kinds of problems. Here I’m going to talk a little bit about how… Continue Reading →

Functions, SQL comparison, count, counting, DECODE, function, greater, less, Oracle, SQL
2

Adding optional conditions to your queries

Posted on August 18, 2015 by Carlos

The NVL function is very useful in a lot of different situations and is probably one of the most widely used among Oracle developers. One of the ways we can use it is to write queries that have ‘optional’ conditions.… Continue Reading →

Functions, SQL condition, NVL, Oracle, query, SQL
7

Oracle NVL, NVL2 and COALESCE functions

Posted on August 13, 2015 by Carlos

I have seen quite a few questions on internet forums and knowledge exchange sites about Oracle NVL, NVL2 and COALESCE functions for handling nulls, so I decided to write an article about them today. Those functions are actually similar, but… Continue Reading →

Functions, SQL COALESCE, function, null, nulls, NVL, NVL2, Oracle, SQL
Don't want to miss any Oracle SQL tips?

Subscribe to be informed about new posts, tips and more awesome things.

Recent Twitter Activity

Recent Tweets by @CarlosDLG

Recent Posts

  • The SQL Group By Clause
  • The Oracle Multitenant Architecture
  • The FIRST and LAST functions in Oracle SQL
  • Pairwise Comparisons With Subqueries in Oracle SQL
  • How to Change Oracle SQL Developer Language

Categories

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

Archives

  • 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
© 2021 Oracle SQL Tips, Tricks and Hacks. All rights reserved.
Hiero by aThemes
Shares