如何通过replace将target="_blank"替换成target='_blank'？急

Question

如何通过replace将target="_blank"替换成target='_blank'？急

Answer 1

select replace('target="_blank"','"','''') from dual;
或者
select replace('target="_blank"',CHR(34),CHR(39)) from dual;CHR(34)表示双引字符"
CHR(39)表示单引字符'

Answer 2

select replace('target="_blank"','"','''') from dual;

Answer 3

select replace(col1,'target="_blank"','target=''_blank''') from table1

Answer 4

replace(字段名,'target="_blank"','target=''_blank''')

Answer 5

select replace('target="_blank"',CHR(34),CHR(39)) from dual;