Seed Media Store Data
The seed_store.sql script adds transaction values to the tables created by the create_store.sql script, as covered in Chapter 13. This model enables you to query and transact against a small database model that illustrates transactional control issues linked to changing data in related tables.
This script contains mostly INSERT statements that use subqueries to pull correct primary key values inserted as foreign keys in the tables. They also demonstrate effective sequencing of tables from the most senior primary key to the most junior foreign key, as well as the use of the .nextval and .currval operations covered in Appendix H. The scripts also demonstrate the Oracle Proprietary and ANSI 1999 INNER JOIN syntax in one of ...
Get Oracle Database 10g Express Edition PHP Web Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
