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!

How to remove certain character from a string?

536042Oct 19 2006 — edited Oct 20 2006

Follows the table:

CT_TRABALH
----------
400rj101
400rj102
400rj103
400rj104
400rj105
400rj106
400rj107
400rj108
400rj109
400rj1010
400rj1011

I woulld like to make the following with its values. For example the value 400rj1010
I would like to remove its last character (400rj101) and then relace the last zero for the last number(400rj111) by query. Is there any way I can achieve this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2006

Added on Oct 19 2006

9 comments

849 views