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?