October 2006
Intermediate to advanced
720 pages
17h 56m
English
This appendix contains the database environment scripts from the enclosed CD. They are too long to print conveniently in Chapters 13, 14, and 15 but do provide written patterns that may be useful to readers. This appendix assumes you will answer basic questions about the Oracle database languages in the SQL and PL/SQL primers, respectively Appendixes H and I.
Database environment scripts are presented in this sequence:
Create system login and logout structures—create_signon_trigger.sql
Create media store structures—create_store.sql
Seed media store data—seed_store.sql
Create and seed PL/SQL example—create_world_leaders.sql
These scripts introduce many concepts of SQL and PL/SQL programming in an Oracle environment. ...
Read now
Unlock full access