Oracle

Oracle TRIM, LTRIM & RTRIM Function Guide, FAQ & Examples

Dec 11, 2017 · 13 min read · sql-functions ·

In this article, you’ll learn all about the three TRIM functions in Oracle (TRIM, LTRIM, and RTRIM).

Oracle NEXT_DAY and LAST_DAY Function Guide, FAQ, and Examples

Nov 26, 2017 · 5 min read · sql-functions ·

The Oracle NEXT\DAY and LAST_DAY functions are similar functions used to determine dates. Learn more about what they can do and their differences in this article.

The Complete Guide to Oracle Sequences

Nov 13, 2017 · 11 min read · sql ·

Share on:

In this article, I’ll explain what an Oracle sequence is, how to create one, and how to use them.

The Complete Guide to Oracle REGEXP Functions

Nov 6, 2017 · 27 min read · sql-functions ·

Share on:

Are you confused by Oracle regular expressions? Want to know how to use them to get the information you need for your queries? Learn all about Oracle REGEXP functions in this article.

Oracle SYSDATE Function Guide, FAQ, & Examples

Oct 30, 2017 · 6 min read · sql-functions ·

Share on:

Oracle SYSDATE is one of the most popular functions in Oracle. Learn what it does and how to SELECT and INSERT it in this article.

The Complete Guide to Oracle Synonyms

Oct 23, 2017 · 7 min read · sql ·

Share on:

In this article, I’ll explain all you need to know about Synonyms.

Oracle SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN Functions

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

Share on:

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

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.

ORA-20000 Cause and Solution

Apr 12, 2017 · 2 min read · sql-errors ·

Share on:

Have you gotten the ORA-20000 error when working with Oracle PL/SQL? Learn what causes it and how to resolve it in this article