GitHub

Reference PL/SQL Variables for APEX Session and App ID

Though minor, could get a small performance gain by just referencing PL/SQL values instead: l_app_session := apex_application.g_instance; l_app_id := apex_application.g_flow_id; In an issue since need ...
GitHub

Oracle PL/SQL Utility Library

This library is a collection of various utility packages for PL/SQL, as well as links to useful libraries hosted and maintained elsewhere. http://ora-00001.blogspot ...
TechRepublic

Avoiding TOO_MANY_ROWS errors in PL/SQL

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

Managing reference tables using Oracle Dynamic SQL and metadata

Abstract: Reference tables are designed to support applications using a relational database management system like Oracle or Sybase. The information in these tables changes over the time. Although a ...
eWeek

A Worthy PL/SQL Workbook

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. “The Oracle PL/SQL Interactive Workbook” ranks right up ...