PL/SQL Advanced

Many developers are familiar with (or at least aware of) try-catch blocks in their codes. These help to isolate parts of codes inside the main program.  Oracle provides a similar …

PL/SQL Nested Blocks Read More

Multidimensional arrays in Oracle PL/SQL can solve some tricky situations you cannot do with nested tables or it will be a bit complex. A multidimensional array is an array of …

Multidimensional Arrays In Oracle PL/SQL Read More

Whenever you create a program block (no matter it is a trigger, procedure, package, …) you have to face errors, in Oracle PL/SQL they are called “exceptions”. We distinguish two …

Exceptions Read More

I dedicated to SYS_CONTEXT function one extra article even though there is nothing much to say 🙂 SYS_CONTEXT is a function used to retrieve information about Oracle environment. There are …

SYS_CONTEXT Read More

SQL injection is a very serious topic and as a matter of fact, it is very easy to prevent. Though, it is overlooked so many times by all developers either …

What Is SQL Injection And How To Avoid It Read More

A package is a schema object that can store variables, functions, procedures, constants, and other objects. The purpose of the package is to improve the modularity, performance, and security of data. The …

Packages Read More

PLSQL offers you an option how to store variables within an array; collections and records. They can hold values that can be treated as standalone values. Collections‘ elements must always …

Collections and Records Read More

This post is not about LOGGING/NOLOGGING table option in Oracle which generates REDO Log entries or bypasses it eventually in case of NOLOGGING. This article is about custom logging feature in …

Logging Read More