troubleshooting Question

Query to find the range of postal codes in Oracle

Avatar of sandy240887
sandy240887 asked on
Oracle Database
6 Comments1 Solution555 ViewsLast Modified:
Hi All,
I need a query where I need the range of postal codes for a
particular county.The query which I wrote gives me
cust_account_number,county_name,state(county_name and state from a custom table and cust_account_number from the hz_cust_accounts table).Now I want two
more columns from_postal_code and to_postal_code.Is there any way in
which I can find out the range of the postal codes for a particular
county from any standard receivables table.

Any help would be really appreciated
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros