Triggers
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 MoreDeveloper's Guide
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 MoreBind 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 MoreThis 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 MoreEven 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 MoreFunctions 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 MoreOracle 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 MoreThere 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 MoreWith 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