Appendix J. Database Setup Scripts

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

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.

Start your free trial