SET echo on; DROP TABLE OrderLineItems; CREATE TABLE OrderLineItems ( OrderId NUMBER(10), LineItemNbr NUMBER(10), ISBN VARCHAR(50), Cost NUMBER(19,4), Quantity NUMBER(10) ); DROP TABLE Customers; CREATE TABLE Customers ( CustId NUMBER(10), FirstName VARCHAR(50), LastName VARCHAR(50), CompanyName VARCHAR(50), Address1 VARCHAR(50), Address2 VARCHAR(50), City VARCHAR(50), State VARCHAR(2), Zip VARCHAR(10), Phone VARCHAR(25), Fax VARCHAR(50) ); DROP TABLE Orders; CREATE TABLE Orders ( OrderId NUMBER(10), CustId NUMBER(10), OrderDate DATE, Status NUMBER(3), TotalCost NUMBER(19,4) ); DROP TABLE Products; CREATE TABLE Products ( Title VARCHAR(50), Author VARCHAR(50), ISBN VARCHAR(50), Cost NUMBER(19,4) ); /