Database Star: Home

Oracle SYSDATE Function Guide, FAQ, & Examples

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

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.

SQL LPAD and RPAD Function Guide, FAQ & Examples

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

Share on:

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.

Database Normalization: A Step-By-Step-Guide With Examples

Sep 30, 2017 · 28 min read · database-design ·

Share on:

In this article, I’ll explain what normalisation in a DBMS is and how to do it, in simple terms.

What Are The DML, DDL, and TCL Commands in SQL?

Sep 25, 2017 · 5 min read · sql ·

Share on:

There are three main types of SQL statements in SQL. Learn what they are and what the commands are 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.

How to Escape Single Quotes in SQL

May 1, 2017 · 4 min read · sql ·

Share on:

Do you need to escape special characters or escape a single quote in SQL? Learn how to do that 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