CREATE TABLE warehouses
  (wh_id NUMBER(2),
   location VARCHAR(12) );
INSERT INTO warehouses
  VALUES (10, 'Boston');
INSERT INTO warehouses
  VALUES (20, 'Norfolk');
INSERT INTO warehouses
  VALUES (30, 'San Diego');
COMMIT;
Create Table Publisher2 
(ID NUMBER(2), 
Name VarCHAR2(23), 
Contact VARCHAR2(15), 
Phone VARCHAR2(12),
  CONSTRAINT publisher2_pubid_pk PRIMARY KEY(id)); 
INSERT INTO PUBLISHER2 
VALUES(1,'PRINTING IS US','TOMMIE SEYMOUR','000-714-8321'); 
INSERT INTO PUBLISHER2 
VALUES(2,'PUBLISH OUR WAY','JANE TOMLIN','010-410-0010'); 
INSERT INTO PUBLISHER2 
VALUES(3,'AMERICAN PUBLISHING','DAVID DAVIDSON','800-555-1211'); 
INSERT INTO PUBLISHER2 
VALUES(4,'READING MATERIALS INC.','RENEE SMITH','800-555-9743'); 
INSERT INTO PUBLISHER2 
VALUES(5,'REED-N-RITE','SEBASTIAN JONES','800-555-8284'); 
commit;