PL/SQL

PL/SQL (Procedural Language/Structured Query Language) is Oracle’s procedural extension for SQL. PL/SQL includes features such as conditional statements, loop processing and exception handling.

Thumbnail image for Simple CASE vs. Searched CASE

Simple CASE vs. Searched CASE

The CASE construct in Oracle has two variants – the simple CASE and the searched CASE. Here’s a closer look to compare them in structure and functionality.

Read the Full Article →
Thumbnail image for The Difference Between DECODE and CASE

The Difference Between DECODE and CASE

Both DECODE and CASE statements in Oracle are used for IF-THEN-ELSE conditional operations, but there are distinct differences in their power and behavior.

Read the Full Article →
Thumbnail image for WHEN OTHERS THEN NULL

WHEN OTHERS THEN NULL

There is a time and place for using exception handlers in Oracle PL/SQL, but you must be extra-wary of the handler WHEN OTHERS THEN NULL. Here’s why.

Read the Full Article →
Thumbnail image for 6 Reasons Why You Should Use PL/SQL Packages

6 Reasons Why You Should Use PL/SQL Packages

When stored procedures/functions can exist standalone, why have packages at all? This article tells you the benefits of using PL/SQL packages.

Read the Full Article →
Page 4 of 4
1
2
3
4