Oracle Character Substitution

1

I have a field in my table with a string like this:

80,82,45,80,82,79,88,73,77,79,32,65,32

I want to replace the comma ( , ) with commas in single quotation marks ( ',' ), to stay:

80','82','45','80','82','79','88','73','77','79','32','65','32

I'm trying this way:

SELECT REPLACE(CAMPO,',','','') 
FROM TABELA;  

But it returns me:

  

ORA-00939: Many arguments to the function.

Does anyone have any suggestions on how to do it?

    
asked by anonymous 25.07.2018 / 23:12

1 answer

3

SELECT REPLACE('80,82,45,80,82,79,88,73,77,79,32,65,32',',',''',''') FROM dual
    
25.07.2018 / 23:21