Using SQL Developer execute the following queries with these statements.

Need help with the joining clauses in SQL. PLEASE help

Write a query to display the title, publisher name, and author FROM publisher, books, and author with a JOIN USING.

Write a query to show the first and last names, e-mail addresses, and the book titles for customers who have actually ordered books. Use the WHERE clause to join the tables.

Write a query to show the title, cost and ISBN of each book in the books table. If the book has been ordered, show the order number and order date. Use the OUTER JOIN keywords to join the tables. Sort the titles in alphabetical order.

Write a query to show the gift a customer will receive if he or she orders Database Implementation. Use either the WHERE clause or a JOIN keyword to join the tables.

Write a query to show the profit of each book sold to customers that live in New Jersey. Calculate the profit by subtracting the cost from the paideach column and multiply by quantity in the orderitems table. Use the WHERE clause to the join the tables.

CREATE TABLE "ABDELLAO"."ACCTBONUS"

( "AMID" CHAR(4 BYTE),

"AMSAL" NUMBER(8,2),

"REGION" CHAR(2 BYTE)

) SEGMENT CREATION DEFERRED

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table ACCTMANAGER

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."ACCTMANAGER"

( "AMID" CHAR(4 BYTE),

"AMFIRST" VARCHAR2(12 BYTE),

"AMLAST" VARCHAR2(12 BYTE),

"AMEDATE" DATE DEFAULT SYSDATE,

"AMSAL" NUMBER(8,2),

"AMCOMM" NUMBER(7,2) DEFAULT 0,

"REGION" CHAR(2 BYTE)

) SEGMENT CREATION DEFERRED

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table ACCTMANAGER2

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."ACCTMANAGER2"

( "AMID" CHAR(4 BYTE),

"AMFIRST" VARCHAR2(12 BYTE),

"AMLAST" VARCHAR2(12 BYTE),

"AMEDATE" DATE DEFAULT SYSDATE,

"REGION" CHAR(2 BYTE)

) SEGMENT CREATION DEFERRED

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table AUTHOR

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."AUTHOR"

( "AUTHORID" VARCHAR2(4 BYTE),

"LNAME" VARCHAR2(10 BYTE),

"FNAME" VARCHAR2(10 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table BOOKAUTHOR

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."BOOKAUTHOR"

( "ISBN" VARCHAR2(10 BYTE),

"AUTHORID" VARCHAR2(4 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table BOOKS

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."BOOKS"

( "ISBN" VARCHAR2(10 BYTE),

"TITLE" VARCHAR2(30 BYTE),

"PUBDATE" DATE,

"PUBID" NUMBER(2,0),

"COST" NUMBER(5,2),

"RETAIL" NUMBER(5,2),

"DISCOUNT" NUMBER(4,2),

"CATEGORY" VARCHAR2(12 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table CUSTOMERS

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."CUSTOMERS"

( "CUSTOMER#" NUMBER(4,0),

"LASTNAME" VARCHAR2(10 BYTE),

"FIRSTNAME" VARCHAR2(10 BYTE),

"ADDRESS" VARCHAR2(20 BYTE),

"CITY" VARCHAR2(12 BYTE),

"STATE" VARCHAR2(2 BYTE),

"ZIP" VARCHAR2(5 BYTE),

"REFERRED" NUMBER(4,0),

"REGION" CHAR(2 BYTE),

"EMAIL" VARCHAR2(30 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table EMPLOYEES

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."EMPLOYEES"

( "EMPNO" NUMBER(4,0),

"LNAME" VARCHAR2(20 BYTE),

"FNAME" VARCHAR2(15 BYTE),

"JOB" VARCHAR2(9 BYTE),

"HIREDATE" DATE,

"DEPTNO" NUMBER(2,0),

"MTHSAL" NUMBER(7,2),

"MGR" NUMBER(4,0)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table ORDERITEMS

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."ORDERITEMS"

( "ORDER#" NUMBER(4,0),

"ITEM#" NUMBER(2,0),

"ISBN" VARCHAR2(10 BYTE),

"QUANTITY" NUMBER(3,0),

"PAIDEACH" NUMBER(5,2)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table ORDERS

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."ORDERS"

( "ORDER#" NUMBER(4,0),

"CUSTOMER#" NUMBER(4,0),

"ORDERDATE" DATE,

"SHIPDATE" DATE,

"SHIPSTREET" VARCHAR2(18 BYTE),

"SHIPCITY" VARCHAR2(15 BYTE),

"SHIPSTATE" VARCHAR2(2 BYTE),

"SHIPZIP" VARCHAR2(5 BYTE),

"SHIPCOST" NUMBER(4,2)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table PROMOTION

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."PROMOTION"

( "GIFT" VARCHAR2(15 BYTE),

"MINRETAIL" NUMBER(5,2),

"MAXRETAIL" NUMBER(5,2)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table PUBLISHER

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."PUBLISHER"

( "PUBID" NUMBER(2,0),

"NAME" VARCHAR2(23 BYTE),

"CONTACT" VARCHAR2(15 BYTE),

"PHONE" VARCHAR2(12 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table PUBLISHER2

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."PUBLISHER2"

( "ID" NUMBER(2,0),

"NAME" VARCHAR2(23 BYTE),

"CONTACT" VARCHAR2(15 BYTE),

"PHONE" VARCHAR2(12 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table PUBLISHER3

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."PUBLISHER3"

( "ID" NUMBER(2,0),

"NAME" VARCHAR2(23 BYTE),

"CONTACT" VARCHAR2(15 BYTE),

"PHONE" VARCHAR2(12 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table TESTING

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."TESTING"

( "ID" NUMBER(2,0),

"TVALUE" VARCHAR2(10 BYTE),

"DESCRIP" VARCHAR2(50 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Table WAREHOUSES

--------------------------------------------------------

CREATE TABLE "ABDELLAO"."WAREHOUSES"

( "WH_ID" NUMBER(2,0),

"LOCATION" VARCHAR2(12 BYTE)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

REM INSERTING into ABDELLAO.ACCTBONUS

SET DEFINE OFF;

REM INSERTING into ABDELLAO.ACCTMANAGER

SET DEFINE OFF;

REM INSERTING into ABDELLAO.ACCTMANAGER2

SET DEFINE OFF;

REM INSERTING into ABDELLAO.AUTHOR

SET DEFINE OFF;

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('S100','SMITH','SAM');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('J100','JONES','JANICE');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('A100','AUSTIN','JAMES');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('M100','MARTINEZ','SHEILA');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('K100','KZOCHSKY','TAMARA');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('P100','PORTER','LISA');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('A105','ADAMS','JUAN');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('B100','BAKER','JACK');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('P105','PETERSON','TINA');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('W100','WHITE','WILLIAM');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('W105','WHITE','LISA');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('R100','ROBINSON','ROBERT');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('F100','FIELDS','OSCAR');

Insert into ABDELLAO.AUTHOR (AUTHORID,LNAME,FNAME) values ('W110','WILKINSON','ANTHONY');

REM INSERTING into ABDELLAO.BOOKAUTHOR

SET DEFINE OFF;

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('0132149871','S100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('0299282519','S100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('0401140733','J100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('1059831198','P100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('1059831198','S100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('1915762492','W100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('1915762492','W105');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('2147428890','W105');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('2491748320','B100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('2491748320','F100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('2491748320','R100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('3437212490','B100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('3957136468','A100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('4981341710','K100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('8117949391','R100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('8843172113','A100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('8843172113','A105');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('8843172113','P105');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('9247381001','W100');

Insert into ABDELLAO.BOOKAUTHOR (ISBN,AUTHORID) values ('9959789321','J100');

REM INSERTING into ABDELLAO.BOOKS

SET DEFINE OFF;

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('1059831198','BODYBUILD IN 10 MINUTES A DAY',to_date('21-JAN-05','DD-MON-RR'),4,18.75,30.95,null,'FITNESS');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('0401140733','REVENGE OF MICKEY',to_date('14-DEC-05','DD-MON-RR'),1,14.2,22,null,'FAMILY LIFE');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('4981341710','BUILDING A CAR WITH TOOTHPICKS',to_date('18-MAR-06','DD-MON-RR'),2,37.8,59.95,3,'CHILDREN');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('8843172113','DATABASE IMPLEMENTATION',to_date('04-JUN-03','DD-MON-RR'),3,31.4,55.95,null,'COMPUTER');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('3437212490','COOKING WITH MUSHROOMS',to_date('28-FEB-04','DD-MON-RR'),4,12.5,19.95,null,'COOKING');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('3957136468','HOLY GRAIL OF ORACLE',to_date('31-DEC-05','DD-MON-RR'),3,47.25,75.95,3.8,'COMPUTER');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('1915762492','HANDCRANKED COMPUTERS',to_date('21-JAN-05','DD-MON-RR'),3,21.8,25,null,'COMPUTER');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('9959789321','E-BUSINESS THE EASY WAY',to_date('01-MAR-06','DD-MON-RR'),2,37.9,54.5,null,'COMPUTER');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('2491748320','PAINLESS CHILD-REARING',to_date('17-JUL-04','DD-MON-RR'),5,48,89.95,4.5,'FAMILY LIFE');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('0299282519','THE WOK WAY TO COOK',to_date('11-SEP-04','DD-MON-RR'),4,19,28.75,null,'COOKING');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('8117949391','BIG BEAR AND LITTLE DOVE',to_date('08-NOV-05','DD-MON-RR'),5,5.32,8.95,null,'CHILDREN');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('0132149871','HOW TO GET FASTER PIZZA',to_date('11-NOV-06','DD-MON-RR'),4,17.85,29.95,1.5,'SELF HELP');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('9247381001','HOW TO MANAGE THE MANAGER',to_date('09-MAY-03','DD-MON-RR'),1,15.4,31.95,null,'BUSINESS');

Insert into ABDELLAO.BOOKS (ISBN,TITLE,PUBDATE,PUBID,COST,RETAIL,DISCOUNT,CATEGORY) values ('2147428890','SHORTEST POEMS',to_date('01-MAY-05','DD-MON-RR'),5,21.85,39.95,null,'LITERATURE');

REM INSERTING into ABDELLAO.CUSTOMERS

SET DEFINE OFF;

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1001,'MORALES','BONITA','P.O. BOX 651','EASTPOINT','FL','32328',null,'SE','bm225@sat.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1002,'THOMPSON','RYAN','P.O. BOX 9835','SANTA MONICA','CA','90404',null,'W ',null);

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1003,'SMITH','LEILA','P.O. BOX 66','TALLAHASSEE','FL','32306',null,'SE',null);

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1004,'PIERSON','THOMAS','69821 SOUTH AVENUE','BOISE','ID','83707',null,'NW','tpier55@sat.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1005,'GIRARD','CINDY','P.O. BOX 851','SEATTLE','WA','98115',null,'NW','cing101@zep.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1006,'CRUZ','MESHIA','82 DIRT ROAD','ALBANY','NY','12211',null,'NE','cruztop@axe.com');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1007,'GIANA','TAMMY','9153 MAIN STREET','AUSTIN','TX','78710',1003,'SW','treetop@zep.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1008,'JONES','KENNETH','P.O. BOX 137','CHEYENNE','WY','82003',null,'N ','kenask@sat.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1009,'PEREZ','JORGE','P.O. BOX 8564','BURBANK','CA','91510',1003,'W ','jperez@canet.com');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1010,'LUCAS','JAKE','114 EAST SAVANNAH','ATLANTA','GA','30314',null,'SE',null);

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1011,'MCGOVERN','REESE','P.O. BOX 18','CHICAGO','IL','60606',null,'N ','reesemc@sat.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1012,'MCKENZIE','WILLIAM','P.O. BOX 971','BOSTON','MA','02110',null,'NE','will2244@axe.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1013,'NGUYEN','NICHOLAS','357 WHITE EAGLE AVE.','CLERMONT','FL','34711',1006,'SE','nguy33@sat.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1014,'LEE','JASMINE','P.O. BOX 2947','CODY','WY','82414',null,'N ','jaslee@sat.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1015,'SCHELL','STEVE','P.O. BOX 677','MIAMI','FL','33111',null,'SE','sschell3@sat.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1016,'DAUM','MICHELL','9851231 LONG ROAD','BURBANK','CA','91508',1010,'W ',null);

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1017,'NELSON','BECCA','P.O. BOX 563','KALMAZOO','MI','49006',null,'N ','becca88@digs.com');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1018,'MONTIASA','GREG','1008 GRAND AVENUE','MACON','GA','31206',null,'SE','greg336@sat.net');

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1019,'SMITH','JENNIFER','P.O. BOX 1151','MORRISTOWN','NJ','07962',1003,'NE',null);

Insert into ABDELLAO.CUSTOMERS (CUSTOMER#,LASTNAME,FIRSTNAME,ADDRESS,CITY,STATE,ZIP,REFERRED,REGION,EMAIL) values (1020,'FALAH','KENNETH','P.O. BOX 335','TRENTON','NJ','08607',null,'NE','Kfalah@sat.net');

REM INSERTING into ABDELLAO.EMPLOYEES

SET DEFINE OFF;

Insert into ABDELLAO.EMPLOYEES (EMPNO,LNAME,FNAME,JOB,HIREDATE,DEPTNO,MTHSAL,MGR) values (7839,'KING','BEN','GTECH2',to_date('17-NOV-91','DD-MON-RR'),10,6000,null);

Insert into ABDELLAO.EMPLOYEES (EMPNO,LNAME,FNAME,JOB,HIREDATE,DEPTNO,MTHSAL,MGR) values (8888,'JONES','LARRY','MTech2',to_date('17-NOV-98','DD-MON-RR'),10,4200,7839);

Insert into ABDELLAO.EMPLOYEES (EMPNO,LNAME,FNAME,JOB,HIREDATE,DEPTNO,MTHSAL,MGR) values (7344,'SMITH','SAM','GTech1',to_date('17-NOV-95','DD-MON-RR'),20,4900,7839);

Insert into ABDELLAO.EMPLOYEES (EMPNO,LNAME,FNAME,JOB,HIREDATE,DEPTNO,MTHSAL,MGR) values (7355,'POTTS','JIM','GTech1',to_date('17-NOV-95','DD-MON-RR'),20,4900,7839);

Insert into ABDELLAO.EMPLOYEES (EMPNO,LNAME,FNAME,JOB,HIREDATE,DEPTNO,MTHSAL,MGR) values (8844,'STUART','SUE','MTech1',to_date('17-NOV-98','DD-MON-RR'),10,3700,8888);

REM INSERTING into ABDELLAO.ORDERITEMS

SET DEFINE OFF;

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1000,1,'3437212490',1,19.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1001,1,'9247381001',1,31.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1001,2,'2491748320',1,85.45);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1002,1,'8843172113',2,55.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1003,1,'8843172113',1,55.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1003,2,'1059831198',1,30.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1003,3,'3437212490',1,19.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1004,1,'2491748320',2,85.45);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1005,1,'2147428890',1,39.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1006,1,'9959789321',1,54.5);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1007,1,'3957136468',3,72.15);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1007,2,'9959789321',1,54.5);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1007,3,'8117949391',1,8.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1007,4,'8843172113',1,55.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1008,1,'3437212490',2,19.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1009,1,'3437212490',1,19.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1009,2,'0401140733',1,22);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1010,1,'8843172113',1,55.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1011,1,'2491748320',1,85.45);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1012,1,'8117949391',1,8.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1012,2,'1915762492',2,25);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1012,3,'2491748320',1,85.45);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1012,4,'0401140733',1,22);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1013,1,'8843172113',1,55.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1014,1,'0401140733',2,22);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1015,1,'3437212490',1,19.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1016,1,'2491748320',1,85.45);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1017,1,'8117949391',2,8.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1018,1,'3437212490',1,19.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1018,2,'8843172113',1,55.95);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1019,1,'0401140733',1,22);

Insert into ABDELLAO.ORDERITEMS (ORDER#,ITEM#,ISBN,QUANTITY,PAIDEACH) values (1020,1,'3437212490',1,19.95);

REM INSERTING into ABDELLAO.ORDERS

SET DEFINE OFF;

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1000,1005,to_date('31-MAR-09','DD-MON-RR'),to_date('02-APR-09','DD-MON-RR'),'1201 ORANGE AVE','SEATTLE','WA','98114',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1001,1010,to_date('31-MAR-09','DD-MON-RR'),to_date('01-APR-09','DD-MON-RR'),'114 EAST SAVANNAH','ATLANTA','GA','30314',3);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1002,1011,to_date('31-MAR-09','DD-MON-RR'),to_date('01-APR-09','DD-MON-RR'),'58 TILA CIRCLE','CHICAGO','IL','60605',3);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1003,1001,to_date('01-APR-09','DD-MON-RR'),to_date('01-APR-09','DD-MON-RR'),'958 MAGNOLIA LANE','EASTPOINT','FL','32328',4);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1004,1020,to_date('01-APR-09','DD-MON-RR'),to_date('05-APR-09','DD-MON-RR'),'561 ROUNDABOUT WAY','TRENTON','NJ','08601',null);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1005,1018,to_date('01-APR-09','DD-MON-RR'),to_date('02-APR-09','DD-MON-RR'),'1008 GRAND AVENUE','MACON','GA','31206',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1006,1003,to_date('01-APR-09','DD-MON-RR'),to_date('02-APR-09','DD-MON-RR'),'558A CAPITOL HWY.','TALLAHASSEE','FL','32307',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1007,1007,to_date('02-APR-09','DD-MON-RR'),to_date('04-APR-09','DD-MON-RR'),'9153 MAIN STREET','AUSTIN','TX','78710',7);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1008,1004,to_date('02-APR-09','DD-MON-RR'),to_date('03-APR-09','DD-MON-RR'),'69821 SOUTH AVENUE','BOISE','ID','83707',3);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1009,1005,to_date('03-APR-09','DD-MON-RR'),to_date('05-APR-09','DD-MON-RR'),'9 LIGHTENING RD.','SEATTLE','WA','98110',null);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1010,1019,to_date('03-APR-09','DD-MON-RR'),to_date('04-APR-09','DD-MON-RR'),'384 WRONG WAY HOME','MORRISTOWN','NJ','07960',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1011,1010,to_date('03-APR-09','DD-MON-RR'),to_date('05-APR-09','DD-MON-RR'),'102 WEST LAFAYETTE','ATLANTA','GA','30311',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1012,1017,to_date('03-APR-09','DD-MON-RR'),null,'1295 WINDY AVENUE','KALMAZOO','MI','49002',6);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1013,1014,to_date('03-APR-09','DD-MON-RR'),to_date('04-APR-09','DD-MON-RR'),'7618 MOUNTAIN RD.','CODY','WY','82414',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1014,1007,to_date('04-APR-09','DD-MON-RR'),to_date('05-APR-09','DD-MON-RR'),'9153 MAIN STREET','AUSTIN','TX','78710',3);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1015,1020,to_date('04-APR-09','DD-MON-RR'),null,'557 GLITTER ST.','TRENTON','NJ','08606',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1016,1003,to_date('04-APR-09','DD-MON-RR'),null,'9901 SEMINOLE WAY','TALLAHASSEE','FL','32307',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1017,1015,to_date('04-APR-09','DD-MON-RR'),to_date('05-APR-09','DD-MON-RR'),'887 HOT ASPHALT ST','MIAMI','FL','33112',3);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1018,1001,to_date('05-APR-09','DD-MON-RR'),null,'95812 HIGHWAY 98','EASTPOINT','FL','32328',null);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1019,1018,to_date('05-APR-09','DD-MON-RR'),null,'1008 GRAND AVENUE','MACON','GA','31206',2);

Insert into ABDELLAO.ORDERS (ORDER#,CUSTOMER#,ORDERDATE,SHIPDATE,SHIPSTREET,SHIPCITY,SHIPSTATE,SHIPZIP,SHIPCOST) values (1020,1008,to_date('05-APR-09','DD-MON-RR'),null,'195 JAMISON LANE','CHEYENNE','WY','82003',2);

REM INSERTING into ABDELLAO.PROMOTION

SET DEFINE OFF;

Insert into ABDELLAO.PROMOTION (GIFT,MINRETAIL,MAXRETAIL) values ('BOOKMARKER',0,12);

Insert into ABDELLAO.PROMOTION (GIFT,MINRETAIL,MAXRETAIL) values ('BOOK LABELS',12.01,25);

Insert into ABDELLAO.PROMOTION (GIFT,MINRETAIL,MAXRETAIL) values ('BOOK COVER',25.01,56);

Insert into ABDELLAO.PROMOTION (GIFT,MINRETAIL,MAXRETAIL) values ('FREE SHIPPING',56.01,999.99);

REM INSERTING into ABDELLAO.PUBLISHER

SET DEFINE OFF;

Insert into ABDELLAO.PUBLISHER (PUBID,NAME,CONTACT,PHONE) values (1,'PRINTING IS US','TOMMIE SEYMOUR','000-714-8321');

Insert into ABDELLAO.PUBLISHER (PUBID,NAME,CONTACT,PHONE) values (2,'PUBLISH OUR WAY','JANE TOMLIN','010-410-0010');

Insert into ABDELLAO.PUBLISHER (PUBID,NAME,CONTACT,PHONE) values (3,'AMERICAN PUBLISHING','DAVID DAVIDSON','800-555-1211');

Insert into ABDELLAO.PUBLISHER (PUBID,NAME,CONTACT,PHONE) values (4,'READING MATERIALS INC.','RENEE SMITH','800-555-9743');

Insert into ABDELLAO.PUBLISHER (PUBID,NAME,CONTACT,PHONE) values (5,'REED-N-RITE','SEBASTIAN JONES','800-555-8284');

REM INSERTING into ABDELLAO.PUBLISHER2

SET DEFINE OFF;

Insert into ABDELLAO.PUBLISHER2 (ID,NAME,CONTACT,PHONE) values (1,'PRINTING IS US','TOMMIE SEYMOUR','000-714-8321');

Insert into ABDELLAO.PUBLISHER2 (ID,NAME,CONTACT,PHONE) values (2,'PUBLISH OUR WAY','JANE TOMLIN','010-410-0010');

Insert into ABDELLAO.PUBLISHER2 (ID,NAME,CONTACT,PHONE) values (3,'AMERICAN PUBLISHING','DAVID DAVIDSON','800-555-1211');

Insert into ABDELLAO.PUBLISHER2 (ID,NAME,CONTACT,PHONE) values (4,'READING MATERIALS INC.','RENEE SMITH','800-555-9743');

Insert into ABDELLAO.PUBLISHER2 (ID,NAME,CONTACT,PHONE) values (5,'REED-N-RITE','SEBASTIAN JONES','800-555-8284');

REM INSERTING into ABDELLAO.PUBLISHER3

SET DEFINE OFF;

Insert into ABDELLAO.PUBLISHER3 (ID,NAME,CONTACT,PHONE) values (2,'PUBLISH OUR WAY','JANE TOMLIN','010-410-0010');

Insert into ABDELLAO.PUBLISHER3 (ID,NAME,CONTACT,PHONE) values (3,'AMERICAN PUB','DAVID DAVIDSON','800-555-1211');

Insert into ABDELLAO.PUBLISHER3 (ID,NAME,CONTACT,PHONE) values (6,'PRINTING HERE','SAM HUNT','000-714-8321');

Insert into ABDELLAO.PUBLISHER3 (ID,NAME,CONTACT,PHONE) values (7,'PRINT THERE','CINDY TIKE','010-410-0010');

REM INSERTING into ABDELLAO.TESTING

SET DEFINE OFF;

Insert into ABDELLAO.TESTING (ID,TVALUE,DESCRIP) values (1,'%ccAccT','Value starts with special character');

Insert into ABDELLAO.TESTING (ID,TVALUE,DESCRIP) values (2,null,'Value is NULL');

Insert into ABDELLAO.TESTING (ID,TVALUE,DESCRIP) values (3,'bccAccT','Value starts with a lowercase b');

Insert into ABDELLAO.TESTING (ID,TVALUE,DESCRIP) values (4,'1ccAccT','Value starts with a number');

Insert into ABDELLAO.TESTING (ID,TVALUE,DESCRIP) values (5,'BccAccT','Value starts with an uppercase B');

Insert into ABDELLAO.TESTING (ID,TVALUE,DESCRIP) values (6,'CccAccT','Value starts with an uppercase C');

Insert into ABDELLAO.TESTING (ID,TVALUE,DESCRIP) values (7,' ccAccT','Value starts with a blank character');

REM INSERTING into ABDELLAO.WAREHOUSES

SET DEFINE OFF;

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (10,'Boston');

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (20,'Norfolk');

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (30,'San Diego');

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (10,'Boston');

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (20,'Norfolk');

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (30,'San Diego');

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (10,'Boston');

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (20,'Norfolk');

Insert into ABDELLAO.WAREHOUSES (WH_ID,LOCATION) values (30,'San Diego');

--------------------------------------------------------

-- DDL for Index ACCTBONUS_AMID_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."ACCTBONUS_AMID_PK" ON "ABDELLAO"."ACCTBONUS" ("AMID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index ACCTMANAGER2_AMID_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."ACCTMANAGER2_AMID_PK" ON "ABDELLAO"."ACCTMANAGER2" ("AMID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index ACCTMANAGER_AMID_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."ACCTMANAGER_AMID_PK" ON "ABDELLAO"."ACCTMANAGER" ("AMID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index AUTHOR_AUTHORID_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."AUTHOR_AUTHORID_PK" ON "ABDELLAO"."AUTHOR" ("AUTHORID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index BOOKAUTHOR_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."BOOKAUTHOR_PK" ON "ABDELLAO"."BOOKAUTHOR" ("ISBN", "AUTHORID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index BOOKS_ISBN_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."BOOKS_ISBN_PK" ON "ABDELLAO"."BOOKS" ("ISBN")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index CUSTOMERS_CUSTOMER#_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."CUSTOMERS_CUSTOMER#_PK" ON "ABDELLAO"."CUSTOMERS" ("CUSTOMER#")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index EMPLOYEES_EMPNO_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."EMPLOYEES_EMPNO_PK" ON "ABDELLAO"."EMPLOYEES" ("EMPNO")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index ORDERITEMS_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."ORDERITEMS_PK" ON "ABDELLAO"."ORDERITEMS" ("ORDER#", "ITEM#")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index ORDERS_ORDER#_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."ORDERS_ORDER#_PK" ON "ABDELLAO"."ORDERS" ("ORDER#")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index PUBLISHER2_PUBID_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."PUBLISHER2_PUBID_PK" ON "ABDELLAO"."PUBLISHER2" ("ID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index PUBLISHER3_PUBID_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."PUBLISHER3_PUBID_PK" ON "ABDELLAO"."PUBLISHER3" ("ID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- DDL for Index PUBLISHER_PUBID_PK

--------------------------------------------------------

CREATE UNIQUE INDEX "ABDELLAO"."PUBLISHER_PUBID_PK" ON "ABDELLAO"."PUBLISHER" ("PUBID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

--------------------------------------------------------

-- Constraints for Table CUSTOMERS

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."CUSTOMERS" MODIFY ("LASTNAME" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."CUSTOMERS" MODIFY ("FIRSTNAME" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."CUSTOMERS" ADD CONSTRAINT "CUSTOMERS_REGION_CK" CHECK (region IN ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E')) ENABLE;

ALTER TABLE "ABDELLAO"."CUSTOMERS" ADD CONSTRAINT "CUSTOMERS_CUSTOMER#_PK" PRIMARY KEY ("CUSTOMER#")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table ORDERITEMS

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."ORDERITEMS" MODIFY ("QUANTITY" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."ORDERITEMS" MODIFY ("PAIDEACH" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."ORDERITEMS" ADD CONSTRAINT "ODERITEMS_QUANTITY_CK" CHECK (quantity > 0) ENABLE;

ALTER TABLE "ABDELLAO"."ORDERITEMS" ADD CONSTRAINT "ORDERITEMS_PK" PRIMARY KEY ("ORDER#", "ITEM#")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table EMPLOYEES

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."EMPLOYEES" MODIFY ("DEPTNO" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."EMPLOYEES" ADD CONSTRAINT "EMPLOYEES_EMPNO_PK" PRIMARY KEY ("EMPNO")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table ACCTMANAGER

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."ACCTMANAGER" MODIFY ("AMFIRST" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."ACCTMANAGER" MODIFY ("AMLAST" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."ACCTMANAGER" ADD CONSTRAINT "ACCTMANAGER_REGION_CK" CHECK (region IN ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E')) ENABLE;

ALTER TABLE "ABDELLAO"."ACCTMANAGER" ADD CONSTRAINT "ACCTMANAGER_AMID_PK" PRIMARY KEY ("AMID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table BOOKAUTHOR

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."BOOKAUTHOR" ADD CONSTRAINT "BOOKAUTHOR_PK" PRIMARY KEY ("ISBN", "AUTHORID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table PUBLISHER3

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."PUBLISHER3" ADD CONSTRAINT "PUBLISHER3_PUBID_PK" PRIMARY KEY ("ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table PUBLISHER2

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."PUBLISHER2" ADD CONSTRAINT "PUBLISHER2_PUBID_PK" PRIMARY KEY ("ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table BOOKS

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."BOOKS" ADD CONSTRAINT "BOOKS_ISBN_PK" PRIMARY KEY ("ISBN")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table AUTHOR

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."AUTHOR" ADD CONSTRAINT "AUTHOR_AUTHORID_PK" PRIMARY KEY ("AUTHORID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table ACCTMANAGER2

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."ACCTMANAGER2" MODIFY ("AMFIRST" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."ACCTMANAGER2" MODIFY ("AMLAST" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."ACCTMANAGER2" ADD CONSTRAINT "ACCTMANAGER2_REGION_CK" CHECK (region IN ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E')) ENABLE;

ALTER TABLE "ABDELLAO"."ACCTMANAGER2" ADD CONSTRAINT "ACCTMANAGER2_AMID_PK" PRIMARY KEY ("AMID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table ACCTBONUS

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."ACCTBONUS" ADD CONSTRAINT "ACCTBONUS_AMID_PK" PRIMARY KEY ("AMID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table ORDERS

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."ORDERS" MODIFY ("ORDERDATE" NOT NULL ENABLE);

ALTER TABLE "ABDELLAO"."ORDERS" ADD CONSTRAINT "ORDERS_ORDER#_PK" PRIMARY KEY ("ORDER#")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Constraints for Table PUBLISHER

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."PUBLISHER" ADD CONSTRAINT "PUBLISHER_PUBID_PK" PRIMARY KEY ("PUBID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE;

--------------------------------------------------------

-- Ref Constraints for Table BOOKAUTHOR

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."BOOKAUTHOR" ADD CONSTRAINT "BOOKAUTHOR_ISBN_FK" FOREIGN KEY ("ISBN")

REFERENCES "ABDELLAO"."BOOKS" ("ISBN") ENABLE;

ALTER TABLE "ABDELLAO"."BOOKAUTHOR" ADD CONSTRAINT "BOOKAUTHOR_AUTHORID_FK" FOREIGN KEY ("AUTHORID")

REFERENCES "ABDELLAO"."AUTHOR" ("AUTHORID") ENABLE;

--------------------------------------------------------

-- Ref Constraints for Table BOOKS

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."BOOKS" ADD CONSTRAINT "BOOKS_PUBID_FK" FOREIGN KEY ("PUBID")

REFERENCES "ABDELLAO"."PUBLISHER" ("PUBID") ENABLE;

--------------------------------------------------------

-- Ref Constraints for Table ORDERITEMS

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."ORDERITEMS" ADD CONSTRAINT "ORDERITEMS_ORDER#_FK" FOREIGN KEY ("ORDER#")

REFERENCES "ABDELLAO"."ORDERS" ("ORDER#") ENABLE;

ALTER TABLE "ABDELLAO"."ORDERITEMS" ADD CONSTRAINT "ORDERITEMS_ISBN_FK" FOREIGN KEY ("ISBN")

REFERENCES "ABDELLAO"."BOOKS" ("ISBN") ENABLE;

--------------------------------------------------------

-- Ref Constraints for Table ORDERS

--------------------------------------------------------

ALTER TABLE "ABDELLAO"."ORDERS" ADD CONSTRAINT "ORDERS_CUSTOMER#_FK" FOREIGN KEY ("CUSTOMER#")

REFERENCES "ABDELLAO"."CUSTOMERS" ("CUSTOMER#") ENABLE;