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;
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
Post a Comment