PL/SQL Nested Blocks
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 MoreDeveloper's Guide
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 MoreMultidimensional 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 MoreWhenever 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 MoreI 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 MoreSQL 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 MoreA 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 MorePLSQL 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 MoreThis 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