oracle - how to update column names for started something in sql -


i'm trying replace column values i'm getting error:

ora-00911: invalid character

my query:

select replace (email, ‘.com’, ‘.net’) emp; 

how resolve it?

use ' instead of

select replace (email, '.com', '.net') emp; 

Comments