Oracle教程上SQL脚本

prompt PL/SQL Developer import file
prompt Created on 2011年1月24日 by xcliub
set feedback off
set define off
prompt Creating AUTHOR...
create table AUTHOR
(
  AUTHORID VARCHAR2(4) not null,
  LNAME    VARCHAR2(10),
  FNAME    VARCHAR2(10)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table AUTHOR
  add primary key (AUTHORID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating BOOKAUTHOR...
create table BOOKAUTHOR
(
  ISBN     VARCHAR2(10) not null,
  AUTHORID VARCHAR2(4) not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table BOOKAUTHOR
  add constraint PK_BOOKAUTHOR primary key (ISBN, AUTHORID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating BOOKS...
create table BOOKS
(
  ISBN     VARCHAR2(10) not null,
  TITLE    VARCHAR2(30),
  PUBDATE  DATE,
  PUBID    NUMBER(2),
  COST     NUMBER(5,2),
  RETAIL   NUMBER(5,2),
  CATEGORY VARCHAR2(12)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table BOOKS
  add primary key (ISBN)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating CUSTOMERS...
create table CUSTOMERS
(
  CUSTOMER# NUMBER(4) not null,
  LASTNAME  VARCHAR2(10),
  FIRSTNAME VARCHAR2(10),
  ADDRESS   VARCHAR2(20),
  CITY      VARCHAR2(12),
  STATE     VARCHAR2(2),
  ZIP       VARCHAR2(5),
  REFERRED  NUMBER(4)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CUSTOMERS
  add primary key (CUSTOMER#)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating ORDERITEMS...
create table ORDERITEMS
(
  ORDER#   NUMBER(4) not null,
  ITEM#    NUMBER(2) not null,
  ISBN     VARCHAR2(10),
  QUANTITY NUMBER(3)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table ORDERITEMS
  add constraint PK_ORDERITEMS primary key (ORDER#, ITEM#)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating ORDERS...
create table ORDERS
(
  ORDER#     NUMBER(4) not null,
  CUSTOMER#  NUMBER(4),
  ORDERDATE  DATE,
  SHIPDATE   DATE,
  SHIPSTREET VARCHAR2(18),
  SHIPCITY   VARCHAR2(15),
  SHIPSTATE  VARCHAR2(2),
  SHIPZIP    VARCHAR2(5)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table ORDERS
  add primary key (ORDER#)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating PROMOTION...
create table PROMOTION
(
  GIFT      VARCHAR2(15),
  MINRETAIL NUMBER(5,2),
  MAXRETAIL NUMBER(5,2)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating PUBLISHER...
create table PUBLISHER
(
  PUBID   NUMBER(2) not null,
  NAME    VARCHAR2(23),
  CONTACT VARCHAR2(15),
  PHONE   VARCHAR2(12)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table PUBLISHER
  add primary key (PUBID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Disabling triggers for AUTHOR...
alter table AUTHOR disable all triggers;
prompt Disabling triggers for BOOKAUTHOR...
alter table BOOKAUTHOR disable all triggers;
prompt Disabling triggers for BOOKS...
alter table BOOKS disable all triggers;
prompt Disabling triggers for CUSTOMERS...
alter table CUSTOMERS disable all triggers;
prompt Disabling triggers for ORDERITEMS...
alter table ORDERITEMS disable all triggers;
prompt Disabling triggers for ORDERS...
alter table ORDERS disable all triggers;
prompt Disabling triggers for PROMOTION...
alter table PROMOTION disable all triggers;
prompt Disabling triggers for PUBLISHER...
alter table PUBLISHER disable all triggers;
prompt Truncating PUBLISHER...
truncate table PUBLISHER;
prompt Truncating PROMOTION...
truncate table PROMOTION;
prompt Truncating ORDERS...
truncate table ORDERS;
prompt Truncating ORDERITEMS...
truncate table ORDERITEMS;
prompt Truncating CUSTOMERS...
truncate table CUSTOMERS;
prompt Truncating BOOKS...
truncate table BOOKS;
prompt Truncating BOOKAUTHOR...
truncate table BOOKAUTHOR;
prompt Truncating AUTHOR...
truncate table AUTHOR;
prompt Loading AUTHOR...
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('S100', 'SMITH', 'SAM');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('J100', 'JONES', 'JANICE');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('A100', 'AUSTIN', 'JAMES');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('M100', 'MARTINEZ', 'SHEILA');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('K100', 'KZOCHSKY', 'TAMARA');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('P100', 'PORTER', 'LISA');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('A105', 'ADAMS', 'JUAN');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('B100', 'BAKER', 'JACK');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('P105', 'PETERSON', 'TINA');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('W100', 'WHITE', 'WILLIAM');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('W105', 'WHITE', 'LISA');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('R100', 'ROBINSON', 'ROBERT');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('F100', 'FIELDS', 'OSCAR');
insert into AUTHOR (AUTHORID, LNAME, FNAME)
values ('W110', 'WILKINSON', 'ANTHONY');
commit;
prompt 14 records loaded
prompt Loading BOOKAUTHOR...
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('0132149871', 'S100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('0299282519', 'S100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('0401140733', 'J100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('1059831198', 'P100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('1059831198', 'S100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('1915762492', 'W100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('1915762492', 'W105');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('2147428890', 'W105');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('2491748320', 'B100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('2491748320', 'F100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('2491748320', 'R100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('3437212490', 'B100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('3957136468', 'A100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('4981341710', 'K100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('8117949391', 'R100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('8843172113', 'A100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('8843172113', 'A105');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('8843172113', 'P105');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('9247381001', 'W100');
insert into BOOKAUTHOR (ISBN, AUTHORID)
values ('9959789321', 'J100');
commit;
prompt 20 records loaded
prompt Loading BOOKS...
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('1059831198', 'BODYBUILD IN 10 MINUTES A DAY', to_date('21-01-2001', 'dd-mm-yyyy'), 4, 18.75, 30.95, 'FITNESS');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('0401140733', 'REVENGE OF MICKEY', to_date('14-12-2001', 'dd-mm-yyyy'), 1, 14.2, 22, 'FAMILY LIFE');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('4981341710', 'BUILDING A CAR WITH TOOTHPICKS', to_date('18-03-2002', 'dd-mm-yyyy'), 2, 37.8, 59.95, 'CHILDREN');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('3437212490', 'COOKING WITH MUSHROOMS', to_date('28-02-2000', 'dd-mm-yyyy'), 4, 12.5, 19.95, 'COOKING');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('3957136468', 'HOLY GRAIL OF ORACLE', to_date('31-12-2001', 'dd-mm-yyyy'), 3, 47.25, 75.95, 'COMPUTER');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('1915762492', 'HANDCRANKED COMPUTERS', to_date('21-01-2001', 'dd-mm-yyyy'), 3, 21.8, 25, 'COMPUTER');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('9959789321', 'E-BUSINESS THE EASY WAY', to_date('01-03-2002', 'dd-mm-yyyy'), 2, 37.9, 54.5, 'COMPUTER');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('2491748320', 'PAINLESS CHILD-REARING', to_date('17-07-2000', 'dd-mm-yyyy'), 5, 48, 89.95, 'FAMILY LIFE');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('0299282519', 'THE WOK WAY TO COOK', to_date('11-09-2000', 'dd-mm-yyyy'), 4, 19, 28.75, 'COOKING');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('8117949391', 'BIG BEAR AND LITTLE DOVE', to_date('08-11-2001', 'dd-mm-yyyy'), 5, 5.32, 8.95, 'CHILDREN');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('0132149871', 'HOW TO GET FASTER PIZZA', to_date('11-11-2002', 'dd-mm-yyyy'), 4, 17.85, 29.95, 'SELF HELP');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('9247381001', 'HOW TO MANAGE THE MANAGER', to_date('09-05-1999', 'dd-mm-yyyy'), 1, 15.4, 31.95, 'BUSINESS');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('2147428890', 'SHORTEST POEMS', to_date('01-05-2001', 'dd-mm-yyyy'), 5, 21.85, 39.95, 'LITERATURE');
insert into BOOKS (ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, CATEGORY)
values ('8843172113', 'DATABASE IMPLEMENTATION', to_date('04-06-1999', 'dd-mm-yyyy'), 3, 31.4, 55.95, 'COMPUTER');
commit;
prompt 14 records loaded
prompt Loading CUSTOMERS...
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1001, 'MORALES', 'BONITA', 'P.O. BOX 651', 'EASTPOINT', 'FL', '32328', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1002, 'THOMPSON', 'RYAN', 'P.O. BOX 9835', 'SANTA MONICA', 'CA', '90404', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1003, 'SMITH', 'LEILA', 'P.O. BOX 66', 'TALLAHASSEE', 'FL', '32306', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1004, 'PIERSON', 'THOMAS', '69821 SOUTH AVENUE', 'BOISE', 'ID', '83707', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1005, 'GIRARD', 'CINDY', 'P.O. BOX 851', 'SEATTLE', 'WA', '98115', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1006, 'CRUZ', 'MESHIA', '82 DIRT ROAD', 'ALBANY', 'NY', '12211', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1007, 'GIANA', 'TAMMY', '9153 MAIN STREET', 'AUSTIN', 'TX', '78710', 1003);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1008, 'JONES', 'KENNETH', 'P.O. BOX 137', 'CHEYENNE', 'WY', '82003', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1009, 'PEREZ', 'JORGE', 'P.O. BOX 8564', 'BURBANK', 'CA', '91510', 1003);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1010, 'LUCAS', 'JAKE', '114 EAST SAVANNAH', 'ATLANTA', 'GA', '30314', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1011, 'MCGOVERN', 'REESE', 'P.O. BOX 18', 'CHICAGO', 'IL', '60606', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1012, 'MCKENZIE', 'WILLIAM', 'P.O. BOX 971', 'BOSTON', 'MA', '02110', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1013, 'NGUYEN', 'NICHOLAS', '357 WHITE EAGLE AVE.', 'CLERMONT', 'FL', '34711', 1006);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1014, 'LEE', 'JASMINE', 'P.O. BOX 2947', 'CODY', 'WY', '82414', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1015, 'SCHELL', 'STEVE', 'P.O. BOX 677', 'MIAMI', 'FL', '33111', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1016, 'DAUM', 'MICHELL', '9851231 LONG ROAD', 'BURBANK', 'CA', '91508', 1010);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1017, 'NELSON', 'BECCA', 'P.O. BOX 563', 'KALMAZOO', 'MI', '49006', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1018, 'MONTIASA', 'GREG', '1008 GRAND AVENUE', 'MACON', 'GA', '31206', null);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1019, 'SMITH', 'JENNIFER', 'P.O. BOX 1151', 'MORRISTOWN', 'NJ', '07962', 1003);
insert into CUSTOMERS (CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED)
values (1020, 'FALAH', 'KENNETH', 'P.O. BOX 335', 'TRENTON', 'NJ', '08607', null);
commit;
prompt 20 records loaded
prompt Loading ORDERITEMS...
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1000, 1, '3437212490', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1001, 1, '9247381001', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1001, 2, '2491748320', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1002, 1, '8843172113', 2);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1003, 1, '8843172113', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1003, 2, '1059831198', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1003, 3, '3437212490', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1004, 1, '2491748320', 2);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1005, 1, '2147428890', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1006, 1, '9959789321', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1007, 1, '3957136468', 3);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1007, 2, '9959789321', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1007, 3, '8117949391', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1007, 4, '8843172113', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1008, 1, '3437212490', 2);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1009, 1, '3437212490', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1009, 2, '0401140733', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1010, 1, '8843172113', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1011, 1, '2491748320', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1012, 1, '8117949391', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1012, 2, '1915762492', 2);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1012, 3, '2491748320', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1012, 4, '0401140733', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1013, 1, '8843172113', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1014, 1, '0401140733', 2);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1015, 1, '3437212490', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1016, 1, '2491748320', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1017, 1, '8117949391', 2);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1018, 1, '3437212490', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1018, 2, '8843172113', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1019, 1, '0401140733', 1);
insert into ORDERITEMS (ORDER#, ITEM#, ISBN, QUANTITY)
values (1020, 1, '3437212490', 1);
commit;
prompt 32 records loaded
prompt Loading ORDERS...
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1001, 1010, to_date('31-05-2003', 'dd-mm-yyyy'), to_date('01-04-2003', 'dd-mm-yyyy'), '114 EAST SAVANNAH', 'ATLANTA', 'GA', '30314');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1000, 1005, to_date('31-03-2003', 'dd-mm-yyyy'), to_date('02-04-2003', 'dd-mm-yyyy'), '1201 ORANGE AVE', 'SEATTLE', 'WA', '98114');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1002, 1011, to_date('31-03-2003', 'dd-mm-yyyy'), to_date('01-04-2003', 'dd-mm-yyyy'), '58 TILA CIRCLE', 'CHICAGO', 'IL', '60605');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1003, 1001, to_date('01-04-2003', 'dd-mm-yyyy'), to_date('01-04-2003', 'dd-mm-yyyy'), '958 MAGNOLIA LANE', 'EASTPOINT', 'FL', '32328');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1004, 1020, to_date('01-04-2003', 'dd-mm-yyyy'), to_date('05-04-2003', 'dd-mm-yyyy'), '561 ROUNDABOUT WAY', 'TRENTON', 'NJ', '08601');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1005, 1018, to_date('01-04-2003', 'dd-mm-yyyy'), to_date('02-04-2003', 'dd-mm-yyyy'), '1008 GRAND AVENUE', 'MACON', 'GA', '31206');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1006, 1003, to_date('01-04-2003', 'dd-mm-yyyy'), to_date('02-04-2003', 'dd-mm-yyyy'), '558A CAPITOL HWY.', 'TALLAHASSEE', 'FL', '32307');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1007, 1007, to_date('02-04-2003', 'dd-mm-yyyy'), to_date('04-04-2003', 'dd-mm-yyyy'), '9153 MAIN STREET', 'AUSTIN', 'TX', '78710');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1008, 1004, to_date('02-04-2003', 'dd-mm-yyyy'), to_date('03-04-2003', 'dd-mm-yyyy'), '69821 SOUTH AVENUE', 'BOISE', 'ID', '83707');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1009, 1005, to_date('03-04-2003', 'dd-mm-yyyy'), to_date('05-04-2003', 'dd-mm-yyyy'), '9 LIGHTENING RD.', 'SEATTLE', 'WA', '98110');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1010, 1019, to_date('03-04-2003', 'dd-mm-yyyy'), to_date('04-04-2003', 'dd-mm-yyyy'), '384 WRONG WAY HOME', 'MORRISTOWN', 'NJ', '07960');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1011, 1010, to_date('03-04-2003', 'dd-mm-yyyy'), to_date('05-04-2003', 'dd-mm-yyyy'), '102 WEST LAFAYETTE', 'ATLANTA', 'GA', '30311');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1012, 1017, to_date('03-04-2003', 'dd-mm-yyyy'), null, '1295 WINDY AVENUE', 'KALMAZOO', 'MI', '49002');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1013, 1014, to_date('03-04-2003', 'dd-mm-yyyy'), to_date('04-04-2003', 'dd-mm-yyyy'), '7618 MOUNTAIN RD.', 'CODY', 'WY', '82414');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1014, 1007, to_date('04-04-2003', 'dd-mm-yyyy'), to_date('05-04-2003', 'dd-mm-yyyy'), '9153 MAIN STREET', 'AUSTIN', 'TX', '78710');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1015, 1020, to_date('04-04-2003', 'dd-mm-yyyy'), null, '557 GLITTER ST.', 'TRENTON', 'NJ', '08606');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1016, 1003, to_date('04-04-2003', 'dd-mm-yyyy'), null, '9901 SEMINOLE WAY', 'TALLAHASSEE', 'FL', '32307');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1017, 1015, to_date('04-04-2003', 'dd-mm-yyyy'), to_date('05-04-2003', 'dd-mm-yyyy'), '887 HOT ASPHALT ST', 'MIAMI', 'FL', '33112');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1018, 1001, to_date('05-04-2003', 'dd-mm-yyyy'), null, '95812 HIGHWAY 98', 'EASTPOINT', 'FL', '32328');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1019, 1018, to_date('05-04-2003', 'dd-mm-yyyy'), null, '1008 GRAND AVENUE', 'MACON', 'GA', '31206');
insert into ORDERS (ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP)
values (1020, 1008, to_date('05-04-2003', 'dd-mm-yyyy'), null, '195 JAMISON LANE', 'CHEYENNE', 'WY', '82003');
commit;
prompt 21 records loaded
prompt Loading PROMOTION...
insert into PROMOTION (GIFT, MINRETAIL, MAXRETAIL)
values ('BOOKMARKER', 0, 12);
insert into PROMOTION (GIFT, MINRETAIL, MAXRETAIL)
values ('BOOK LABELS', 12.01, 25);
insert into PROMOTION (GIFT, MINRETAIL, MAXRETAIL)
values ('BOOK COVER', 25.01, 56);
insert into PROMOTION (GIFT, MINRETAIL, MAXRETAIL)
values ('FREE SHIPPING', 56.01, 999.99);
commit;
prompt 4 records loaded
prompt Loading PUBLISHER...
insert into PUBLISHER (PUBID, NAME, CONTACT, PHONE)
values (1, 'PRINTING IS US', 'TOMMIE SEYMOUR', '000-714-8321');
insert into PUBLISHER (PUBID, NAME, CONTACT, PHONE)
values (2, 'PUBLISH OUR WAY', 'JANE TOMLIN', '010-410-0010');
insert into PUBLISHER (PUBID, NAME, CONTACT, PHONE)
values (3, 'AMERICAN PUBLISHING', 'DAVID DAVIDSON', '800-555-1211');
insert into PUBLISHER (PUBID, NAME, CONTACT, PHONE)
values (4, 'READING MATERIALS INC.', 'RENEE SMITH', '800-555-9743');
insert into PUBLISHER (PUBID, NAME, CONTACT, PHONE)
values (5, 'REED-N-RITE', 'SEBASTIAN JONES', '800-555-8284');
commit;
prompt 5 records loaded
prompt Enabling triggers for AUTHOR...
alter table AUTHOR enable all triggers;
prompt Enabling triggers for BOOKAUTHOR...
alter table BOOKAUTHOR enable all triggers;
prompt Enabling triggers for BOOKS...
alter table BOOKS enable all triggers;
prompt Enabling triggers for CUSTOMERS...
alter table CUSTOMERS enable all triggers;
prompt Enabling triggers for ORDERITEMS...
alter table ORDERITEMS enable all triggers;
prompt Enabling triggers for ORDERS...
alter table ORDERS enable all triggers;
prompt Enabling triggers for PROMOTION...
alter table PROMOTION enable all triggers;
prompt Enabling triggers for PUBLISHER...
alter table PUBLISHER enable all triggers;
set feedback on
set define on
prompt Done.