Oracle9i™ Development by Example

Chapter 11 Objects 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 August 2001 rem All Rights Reserved rem drop table st_cars_for_sale; create table st_cars_for_sale ( inv_id Number , auto_description VARCHAR2(60) , sale_amt number , sale_photo_location VARCHAR2(50) , buyer_name VARCHAR2(20) , buyer_phone VARCHAR2(10) , buyer_offer number , buyer_date date ); insert into st_cars_for_sale values (1,'2000 Austin Martin DB7 Coupe' ,142000,'/austinmartin.jpg',null,null,null,null); insert into st_cars_for_sale values (2,'1999 Lexus ES300', 29000,'/lexuses300.jpg',null,null,null,null); ...