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 statements to …

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 manage database tables …

This PL/SQL Tutorial section teaches you how to use PL/SQL programming language to develop modular and procedural programs in Oracle Database.

This section shows you advanced SQL techniques to help you solve difficult problems in data using Oracle SQL.

PL/SQL is an extension to the SQL language, specifically designed for the Oracle Database. While SQL is excellent for interacting with data in a relational database management system (RDBMS), it is not …

This tutorial shows you how to deal with PL/SQL exception such as declaring user-defined exception, raising an exception and handling it.

This tutorial shows you how to use the Oracle NOT EXISTS operator to subtract one set of data from another.

This tutorial shows you how to use the Oracle DECODE () function to add the procedural if-then-else logic to SQL queries.

This tutorial shows you how to use Oracle SELECT statement to retrieve data from one or more columns of a table.

In this tutorial, you have learned about the Oracle statement-level triggers and how to use the CREATE TRIGGER statement to create a new statement-level trigger in the database.