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!

Replace problem

513219Sep 27 2006 — edited Nov 28 2006

Hi,

I have a string e.g. "a% b% impex% for% 1% and% 3% slabs%'

I want to convert this string as follows: " a b impex% for% 1 and% 3 slabs%"

Basically I want to remove % sign from all single characters in the string, weather in begining, middle or at end.

Is it possible to do it using REPLACE Command?

Regards
Madhup

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2006

Added on Sep 27 2006

19 comments

739 views