DROP TABLE XCUSTOMERS;  

CREATE TABLE XCUSTOMERS ( 
    CUSTNO     NUMBER(9)  NOT NULL PRIMARY KEY,
    CUSTNAME   CHAR(20),
    CUSTCITY   CHAR(20)); 


INSERT INTO XCUSTOMERS  VALUES(1000,'Guy, Buddy','Chicago'); 
INSERT INTO XCUSTOMERS  VALUES(1001,'Rush, Otis','Chicago'); 
INSERT INTO XCUSTOMERS  VALUES(1002,'Clapton, Eric','London'); 
INSERT INTO XCUSTOMERS  VALUES(1003,'Green, Peter','London'); 
INSERT INTO XCUSTOMERS  VALUES(1004,'Bloomfield, Mike','Chicago'); 
INSERT INTO XCUSTOMERS  VALUES(1005,'King, Freddie','Dallas'); 
INSERT INTO XCUSTOMERS  VALUES(1006,'King, B.B.','Memphis');