View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 11:57 AM
John
 
Posts: n/a
Default 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

Reply With Quote