Remove Oracle Simple Quotes

0

Good morning,

How can I remove single quotation marks from a string in the oracle database? If I do Replace (test, '' ',' ') is not right.

Thank you.

    
asked by anonymous 11.12.2017 / 13:43

1 answer

1

You have to give escape :

REPLACE (teste, '''', '')
    
11.12.2017 / 13:45