Sql-Functions

Oracle SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN Functions

Oct 16, 2017 · 4 min read · sql-functions ·

In this article, I’ll explain what an SCN is and how to use both the SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN function.

SQL LPAD and RPAD Function Guide, FAQ & Examples

Oct 7, 2017 · 10 min read · sql-functions ·

The SQL LPAD and RPAD functions can be quite useful in your queries. Learn more about the LPAD and RPAD functions and see some examples in this article.

Oracle SYS_EXTRACT_UTC Function Guide, FAQ, and Examples

Sep 19, 2017 · 3 min read · sql-functions ·

Share on:

In this article, I’ll explain what the SYS_EXTRACT_UTC function does and show you some examples.

Oracle Date Functions: The Complete Guide

Sep 11, 2017 · 27 min read · sql-functions ·

Share on:

There are many different date and time functions in Oracle, and they behave differently than other databases. Learn what they are and see some useful queries in this article.

Oracle TO_DATE Function Usage, Tips & Examples

Nov 15, 2016 · 6 min read · sql-functions ·

Share on:

The Oracle TO_DATE function is one of the most common and useful string manipulation functions in Oracle, but it can be confusing. I'll explain how to use the TO_DATE function in this article.

Oracle BFILENAME Function Explained with Examples

Aug 11, 2016 · 2 min read · sql-functions ·

Share on:

The Oracle BFILENAME function is a useful file manipulation function. Learn what it is and how to use it in this article.

Oracle SOUNDEX Function with Examples

Jun 30, 2016 · 4 min read · sql-functions ·

Share on:

The Oracle SOUNDEX function is one of the most interesting functions I've used in Oracle. Learn what it is and how it works in this article.

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.