Oracle

How to Limit the Number of Rows in Oracle SQL After Ordering

Apr 18, 2016 · 5 min read · sql ·

In this article, I'll show you how you can limit the number of rows in Oracle SQL.

How to Select Rows with Max Value for a Column in Oracle SQL

Apr 4, 2016 · 7 min read · sql ·

A common question in Oracle SQL, and SQL in general, is to select rows that match a maximum value for a column. Let's see how you can do that in SQL.

Oracle SYS_CONTEXT Function with Examples (including Oracle 12C)

Mar 13, 2016 · 10 min read · sql-functions ·

Share on:

The SYS_CONTEXT function is an Oracle function that checks configuration values on the database. Learn how to use it and see some examples in this article.

Oracle EXTRACT Function Explained with Examples

Dec 31, 2015 · 5 min read · sql-functions ·

Share on:

The Oracle EXTRACT function is very useful when you're doing any work with a date field or date expression. Let's learn what it is and see some examples in this article.

Oracle DUMP Function Explained with Examples

Dec 17, 2015 · 4 min read · sql-functions ·

Share on:

The Oracle DUMP function tells you the data type of an expression. Let's learn how to use it and see some examples in this article.

Oracle CONVERT Function Explained with Examples

Nov 26, 2015 · 4 min read · sql-functions ·

Share on:

The Oracle CONVERT function doesn't do what you might expect it do, if you just look at its name. Learn what this function does and how to use it in this article.

Oracle TRANSLATE Function Explained with Examples

Nov 19, 2015 · 5 min read · sql-functions ·

Share on:

The Oracle TRANSLATE function is a similar function to REPLACE, but it has a few differences. Learn what the differences are and see some examples in this article.

Oracle TO_TIMESTAMP Function with Examples

Oct 8, 2015 · 3 min read · sql-functions ·

Share on:

The Oracle TO_TIMESTAMP function is useful if you need to work with timestamp data types. Learn how to use it with some examples in this article.

Oracle SUBSTR Function Explained with Examples

May 23, 2015 · 8 min read · sql-functions ·

Share on:

The Oracle SUBSTR function is used to get a smaller string (the substring) from within a larger string. Let's take a look at how you can use it and some examples.

Oracle LISTAGG Function Usage, Tips & Examples

May 14, 2015 · 9 min read · sql-functions ·

Share on:

This article explains the Oracle LISTAGG functions, which is one of the more difficult functions to understand. Purpose of the Oracle LISTAGG Function The purpose of the Oracle LISTAGG function is to allow you to perform aggregation of strings from data in columns. What is string aggregation? Well, it's a technique …