PL/SQL (MOSC)

MOSC Banner

Getting number in string and text after number(Challenge)

edited Oct 21, 2014 10:02AM in PL/SQL (MOSC) 3 commentsAnswered

Hi,

I have varchar2 column which contain customer address in format

address space house_number space house extension

address=alphabatic chracters

house number =numeric

house extension =alphabatic chracters+number or null

I have to get these values and store in seperate fields and house_number is null or house_extension is null return nothing.

I have tried everything but failed.

example is

Förenta Staterna 7 X1

thanks,

7Z

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center