This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Oct 3, 2012 6:59 AM by ranit B RSS

replace special characters

user9972431 Newbie
Currently Being Moderated
Hi,
RDBMS : Oracle 10.2

In one of my table column, I have special characters. I want to replace them with single '-'.
Table : Item
ID Number
size varchar2

Select id,size from item where size like '%�%'; -- this query produce following results
Id Size
8080193     Ladies Sizes: XS¿¿¿4XL
8080217     Ladies Sizes: XS¿¿¿4XL
8080592     Juniors Sizes: XS¿¿¿4XL
8080210     Ladies Sizes: XS¿¿¿4XL
8080566     Juniors Sizes: XS¿¿¿4XL
----
-----

Now I want to update these special character to a single '-'. how Can I do this with sql ?

Id Size
8080193     Ladies Sizes: XS-4XL
8080217     Ladies Sizes: XS-4XL
8080592     Juniors Sizes: XS-4XL
8080210     Ladies Sizes: XS-4XL
8080566     Juniors Sizes: XS-4XL
....
....

thanks
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points