Remove Oracle Single Quotes

Asked

Viewed 2,504 times

1

How do I remove simple quotes from a string in the Oracle database? If I do Replace(teste, ''', '') doesn’t work.

oracle

  • when you use only two quotes, you are saying that you are looking for something empty, the correct is to use 4 quotes, so you will look for a quote in the middle of a text.

  • Example Onlline

  • That was it, thank you.

1 answer

3


You have to give one escape:

REPLACE (teste, '''', '')

Browser other questions tagged oracle

You are not signed in. Login or sign up in order to post.