DROP TABLE POSTALCODES;
CREATE TABLE POSTALCODES
(
POSTALCODE VARCHAR(12) NOT NULL,
CITY VARCHAR(30) NOT NULL,
STATEPROV VARCHAR(30) NOT NULL,
COUNTRYID NUMBER(10) NOT NULL
);
INSERT INTO POSTALCODES VALUES('06484','Shelton','CT',1);
INSERT INTO POSTALCODES VALUES('06488','Southbury','CT',1);
INSERT INTO POSTALCODES VALUES('06877','West Haven','CT',1);
INSERT INTO POSTALCODES VALUES('06628','Trumbull','CT',1);
INSERT INTO POSTALCODES VALUES('10022','Manhattan','NY',1);
INSERT INTO POSTALCODES VALUES('06601','Bridgeport','CT',1);
INSERT INTO POSTALCODES VALUES('92121','San Diego','CA',1);
INSERT INTO POSTALCODES VALUES('90232','Culver City','CA',1);
INSERT INTO POSTALCODES VALUES('33487','Boca Raton','FL',1);
INSERT INTO POSTALCODES VALUES('06602','Bridgeport','CT',1);