PL/SQL Basic

Database triggers are procedures that are fired/executed/triggered before or after data manipulation commands (DML). There are also “system triggers” that can be fired by other actions; such as logon, logoff, …

Triggers Read More

Bind variables are an integral part of every application. There is no chance that any application will work correctly without them. It all about performance and understanding of Oracle’s architecture. …

Bind Variables Read More

This article will be pretty short because I don’t want to write about what are regular expressions capable of (foremost because I am not fond of them). There are many …

Regular Expressions Read More

Even though there is no native debugger for PL/SQL you are still able to debug your code. PL/SQL, as well as any other procedural language, can fail on syntax/semantics checks …

Debugging Read More

Functions are very handy in order to customize your own computation logic. Unlike procedures, they return a value and therefore might be used in a SELECT statement. Functions are sometimes …

Functions Read More

Oracle procedures are stored blocks of code that you can call anytime you want with or without parameters. It is especially handy when you need to call the same code …

Procedures Read More

There are cases where you need to run a certain block multiple times. LOOPs are the answer. With them, you can define the logic when to exit the loop; whether …

Loops / Cursors Read More

With SQL queries you can easily extract or manipulate data in the database. But in order to make it sophisticated and implement some logic; SQL is simply not enough. This …

Introduction to PL/SQL Read More