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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

To remove last '/' character

966822Oct 8 2012 — edited Oct 8 2012

I need to remove '/' character and string comes after it. I will give an example.

CREATE TABLE TAB (COL1 VARCHAR2(50));

INSERT INTO TAB VALUES ('hIA/SS/TTTT/FFFF');

INSERT INTO TAB VALUES ('hDFF/AA/S/AAAAAAAA');

I should remove the last '/' and string comes after it so when i query , i should get result as

hiA/SS/TTTT
hDFF/AA/S

Please help me

This post has been answered by chris227 on Oct 8 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2012

Added on Oct 8 2012

3 comments

1,036 views