Oracle9i™ Development by Example

Sales Tracking Object Setup Script

All these scripts and test data are available at www.quepublishing.com. Put 0789726718 in the search field.

 rem rem Sales Tracking Application Oracle9i Objects rem Oracle9i Development By Example rem by Dan Hotka rem Que Publications May 2001 rem All Rights Reserved rem spool INSTALL_sales_tracking_objects.log DROP TABLE st_inventory CASCADE CONSTRAINTS; DROP SEQUENCE st_inv_seq; DROP TABLE st_parts CASCADE CONSTRAINTS; DROP TABLE st_inv_type CASCADE CONSTRAINTS; DROP TABLE st_inv_make CASCADE CONSTRAINTS; DROP TABLE st_inv_model CASCADE CONSTRAINTS; DROP TABLE st_vendor CASCADE CONSTRAINTS; DROP SEQUENCE st_vendor_seq; DROP TABLE st_customer CASCADE CONSTRAINTS; DROP TABLE st_staff CASCADE CONSTRAINTS; DROP ...