I want to replace (') by (`). Can anybody help me out.
Thankx in advance.
Printable View
I want to replace (') by (`). Can anybody help me out.
Thankx in advance.
Use replace function.
REPLACE (string,string_to_replace,replacement_string).
example:
REPLACE('ADAH','A','BLAH') = BLAHDBLAHH
will this do?
SQL> select replace ('soni''ji','''','`') from dual;
REPLACE
-------
soni`ji
P.Soni