ADD_ZIP

procedure add_zip(
      zip zipcodes.zip%type,
      city zipcodes.city%type) as
begin
  insert into zipcodes values (zip,city);
end;