select given_name || ' ' || family_name as pretty_name from contacts where contact_id = :contact_id select description, address_type_id from cn_address_types select default_name, iso from countries where default_name != 'UNITED STATES' select state_name,abbrev from us_states order by state_name select c.contact_id, family_name, given_name, address_id, delivery_address, postal_code, municipality, region, country_code, address_type_id from contacts c , cn_addresses a where a.address_id = :address_id and c.contact_id = a.contact_id update cn_addresses set contact_id = :contact_id, delivery_address = :delivery_address, postal_code = :postal_code, municipality = :municipality, region = :region, country_code = :country_code, address_type_id = :address_type_id where address_id = :address_id