I hardly remember to have encountered with a subprograms without a conditional clause, are we not widely using the conditional structs...

I had been going pity busy in recent time with several interviews scheduled. Every interview i took, Otherwise different in their...

Inlining replaces a subprogram call (to a subprogram in the same program unit) with a copy of the called subprogram. Pragma inline could...

The SERIALLY_REUSABLE Pragma specifies that the package state is needed for only one call to the server (for example, an OCI call to the...

PL/SQL was first released in 1992 as an optional extension to Oracle 6. In its initial years it lacked the optimizations needed to...

This post is a continuation of my prior blogs in Oracle Jason, which gave us an insight on Oracle Jason - Storing Jason data and...

Bulk collect is one of my favourite features in PL/SQL programming. It gains significance when you require better performing code using...

I have come across the table functions in Oracle during the initial years of my career but rarely spared time to delve deeper into it...

Uploading Data files in oracle is nothing new. Many of us have been doing it for years but playing with JASON files is something that...