The Oracle basics section teaches you about how to use SQL to interact with the Oracle database. You will learn various techniques to query data from the database and how to …

The primary goal of this tutorial series is to assist you in establishing a solid foundation in the Oracle Database. After completing this series, you will have the ability to write complex SQL …

Summary: In this tutorial, you will learn how to use the Oracle SELECT statement to query data from a single table. Introduction to Oracle SELECT statement # In Oracle, tables consist of …

This tutorial shows you how to use the Oracle subquery to construct more readable queries without using complex joins or unions.

In this tutorial, you will learn various kind of Oracle joins that allow you to query data from two or more related tables.

This section shows you advanced Oracle SQL techniques including views, indexes, synonyms, and sequences.

This tutorial shows you how to use the Oracle FETCH clause to limit the number of rows returned by a query.

This tutorial shows you how to use the Oracle WHERE clause to specify a search condition for rows returned by a query.

This tutorial shows you how to use the Oracle SUBSTR() function to extract a substring from a string in the database.

Summary: in this tutorial, you will learn how to use the Oracle DECODE() function to embed if-then-else logic in SQL queries. Introduction to Oracle DECODE() function # The Oracle …