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

Month: August 2015

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

How to change Oracle SQL Developer language

Posted on August 8, 2015 by Carlos

Today I installed SQL developer 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 usually like to have programs installed in… Continue Reading →

SQL Developer English, language, Oracle, Spanish, SQL Developer, user interface
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