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!

removing more than one underscore in a string

713263Oct 23 2009 — edited Oct 23 2009

Hi All,

i have column called tax_name, it stores the values as
1. 'Service @ 5 %'
2. 'Service Tax - Consulting Services' etc..

using RTRIM(LTRIM(SUBSTRB(REPLACE(TRANSLATE (

i have converted them to Service__5_Amt, Service_Tax__Consulting_Amt etc.. using

Now how to remove more than one underscore from above literals.

There may be many underscores consecutively due to the conversion of wild characters into underscores.

if there are three wild characters continously there will be three underscores. So i want remove those and put only 1 underscore.

This post has been answered by Karthick2003 on Oct 23 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 20 2009

Added on Oct 23 2009

#pl-sql, #plsql, #sql

5 comments

2,150 views