Hi Guys,
Very good morning!
I need help on writing query to extract the “state” and “zip_code” from address column in Oracle 19c database.
NOTE: If zip code is not present against state/region, I want to hardcode actual zip_code of the respective state and display.
can some one write a query or advice me possible ways to get the zip codes against each state/region across USA.
Thanks in advance!
Regards,
LRK