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!

Trim or Regexp?

976439Feb 27 2013 — edited Feb 28 2013

Hi, i am just trying to work something regarding removing the first characters of a text string based on a condition. i have a column with various text strings, and I have noticed some text fields have 4 letters at the start that I would like to remove i.e. AN01 and SA01 but i am not too sure if the sql code should be written using the TRIM function or REGEXP_REPLACE so just wanted to find out what the correct method would be. If somebody could please advise.

Thanks in advance.

This post has been answered by 636309 on Feb 27 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2013

Added on Feb 27 2013

5 comments

417 views