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!

Remove Hyphen At The Start Of A String

Angus123Jul 21 2023

Hi

If the first character of a string is a hyphen, I need to remove it.

I can do it with

select ltrim(TRANSLATE('-bank1234''','-''',' '))
from dual

but is there a better way

Regards

Gus

Comments
Post Details
Added on Jul 21 2023
4 comments
952 views