The first PL/SQL code elements to review when deciding how to properly use SQL inside of PL/SQL are cursors. The battle between proponents of implicit vs. explicit cursors is as old as Oracle databases. Sadly, online fighters often miss the key feature of database cursors, namely that they are nothing more than pointers to SQL…

Learn how to use Oracle SQL Developer PL/SQL Unit Test capabilities to define and create PL/SQL unit tests. Harper will also show readers how to add reusable test components to a unit test library and how to define and handle test exceptions.

Learn how to use Oracle SQL Developer PL/SQL Unit Test capabilities to define and create PL/SQL unit tests. Harper will also show readers how to add reusable test components to a unit test library and how to define and handle test exceptions.

Bulusu describes a framework for debugging PL/SQL application code.

Bulusu describes a framework for debugging PL/SQL application code.

Bulusu describes a framework for debugging PL/SQL application code.

Bulusu describes a framework for debugging PL/SQL application code.

Bulusu describes a framework for debugging PL/SQL application code.

Bulusu describes a framework for debugging PL/SQL application code.

Increasingly, companies are considering public cloud computing solutions, including Oracle's on demand and other software-as-a-service (SaaS) applications. However, the adoption of this new breed of applications introduces a technological divide between privately owned datacenters and third-party public clouds, resulting in an array of new challenges to overcome and a new level of management complexity to…