Oracle Database 10g Express Edition PHP Web Programming

Create and Seed PL/SQL Example

The create_world_leaders.sql script is a rerunnable example program that creates a table, sequence, and package with overloaded procedures. It also seeds data into the PRESIDENT table and tests the implementation of all four overloaded procedures. The package demonstrates the management of user-defined scalar variable collections, associative arrays also known as PL/SQL tables, and reference cursors.

The program is fully commented with delimited comment breaks for major sections, like seeding the 42 presidents of the United States, defining the scalar variable collections, defining the package specification and body, and testing the data and PL/SQL code. The latter section is an important tool because it enables ...