How would I concatenate an address in multiple rows using Oracle SQL?
The address should be in one row using the following format ("address, city, state. zipcode").
The table name is vendors and the rows are vendor_address, vendor_city, vendor_state, and vendor_zip_code.