I want to replace (') by (`). Can anybody help me out. Thankx in advance.
When the going gets tough, the tough gets going
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
Forum Rules