Skip to Main Content

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!

reverse non numeric char in string

NaamasApr 3 2019 — edited Apr 4 2019

Hi all ,

I have a given string like this :

sd"sageV saL 98 aera

need to reverse it like this

Area 98 Las Vegas"ds

problemĀ  : while using the reverse function it also reverse the number instead of 98 to 89 .

What reg expression can i use in order to avoid it , please donate the whole function .

Thanks In Advanced ,

Naama

This post has been answered by mathguy on Apr 3 2019
Jump to Answer
Comments
Post Details
Added on Apr 3 2019
11 comments
2,326 views