Accesses the city versus zip code database.
Finds all the zip codes and cities.
SELECT * FROM DEMO.CITY_TAB
Finds the city for a zip code.
SELECT CITY FROM DEMO.CITY_TAB WHERE ZIPCODE = :zipcode
Finds the zip codes for a city.
SELECT ZIPCODE FROM DEMO.CITY_TAB WHERE CITY = :city
Inserts a new zip code and city into the database.
INSERT INTO DEMO.CITY_TAB (ZIPCODE, CITY) VALUES (:zipcode, :city)
Updates the city for a zip code.
UPDATE DEMO.CITY_TAB SET CITY = :city WHERE ZIPCODE = :zipcode
Deletes a zip code from the database.
DELETE FROM DEMO.CITY_TAB WHERE ZIPCODE = :zipcode
Deletes a city from the database.
DELETE FROM DEMO.CITY_TAB WHERE CITY = :city