Menu Home

Sorting an Oracle Nested Table

This article demonstrates a method used to sort an Oracle nested table collection from within PL/SQL . The example that follows was built using the Oracle Developer Days Environment and used the following versions: Oracle Linux running via Oracle Virtual Box Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 Oracle SQL […]

Getting Started with DBMS_PARALLEL_EXECUTE

In this article I will explain what DBMS_PARALLEL_EXECUTE is and give an example of it’s use. DBMS_PARALLEL_EXECUTE is an Oracle Supplied package which was introduced with Oracle Database 11g Release 2. It allows you to execute a SQL or PLSQL statement in parallel. At a high level DBMS_PARALLEL_EXECUTE works by […]