SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get postcode district from a postcode uk

user5716448Sep 17 2021

Hi,

version 11.2.03

Looking for best way to get postcode district from a postcode.

Can use below for good postcodes but if user has postcode with no space looking for best way to cater for scneraios of postcode with spave and withput space if possible
upper(substr('<postcode>', 1, instr('<postcode>', ' ') - 1))

Just wondered as to thought as to best way.

Thanks

This post has been answered by Jan Gorkow on Sep 17 2021

Jump to Answer

Added on Sep 17 2021

7 comments

1,521 views

1 mention