Oracle Database 10g Express Edition PHP Web Programming

Create Media Store Structures

The create_store.sql script builds a set of tables and views to run a video store. It also creates SYSTEM_USER and COMMON_LOOKUP tables to introduce some application design components to the model. The script seeds data in the infrastructure tables. These seeded values enable the seed_store.sql script to use subqueries in the insert statements to capture foreign key values from the table that holds the lists of primary keys.

Building the environment enables you to query and transact against multiple tables in Chapter 13 example programs; enables you to examine transaction patterns; and illustrates the purpose of persistent connections. This model also highlights the benefits of building stored procedures on the ...