SQL problem: How replace all ' with " from a column in a table? Hello,
we have Oracle 9, and now I'm faced with this problem:
I have to update an entire column from a table which contains the
character
' (single quotes)
and replace it with
" (double quotes)
The column is about "Descriptions", and now the customer wants to
replace all occurences of the single quote with the double quote.
If it can help you I give you the names:
- table name: EVENT_LOGS
- column name: DESCRIPTION
- current character (eliminate): '
- to replace character: "
Can somebody please indicate me an SQL statement for updating the table
a replace all single quotes with double quotes?
Thank you very much for your help and have a good day
John |