Mastering Common Database Objects - Series 1 .. n

In the series, I hope to cover some common database objects such as procedures, functions, triggers etc. while also providing frequent real-life scenarios where these objects are used. The scope of this series will be limited to the oracle PL SQL syntax. However, most objects exist in other database technologies and I am pretty sure that the knowledge gotten here will be transferable to other RDBMS systems.

Get ready!!

Each coming article will focus on one database object only and will contain code snippets. The objects that will be covered are:

1. Procedures
2. Functions
3. Packages
4. Custom data types
5. Database Triggers

Coming Soon

1. Cursors
2. Jobs