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...

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...

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...

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...