These settings have been defined and tested with the product versions mentioned above. They might not work in other versions. Please note, that these settings cannot ...

Today, I want to talk about some useful information, tricks and common mistakes about PL/SQL. Even you are a junior or an advanced PL/SQL developer, I admire you will find them useful. Let's start.

In this blog, we have covered the Bulk Collect and For All option along with Context switches which shares a PL/SQL run time engine. So, let us start with Bulk Collect first. What is BULK COLLECT? The ...

PL/SQL Unwrapper for SQL Developer is a free extension to unwrap PL/SQL code wrapped with the wrap utility of the Oracle Database Server version 10g, 11g, 12c, 18c or 19c. Open a wrapped PL/SQL unit ...

Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...