去掉bbb: substr(abcd, 1, 4)||substr(abcd, 8, 6)
改为eee: substr(abcd, 1, 4)||'eee'||substr(abcd, 8, 6)
查出aaaa: select * from table where abcd like 'aaaa%';
改为eee: substr(abcd, 1, 4)||'eee'||substr(abcd, 8, 6)
查出aaaa: select * from table where abcd like 'aaaa%';
改为eee: substr(abcd, 1, 4)||'eee'||substr(abcd, 8, 6)
-->
select replace(abcd, 'b', 'e')
------------------------------
aaaaeeecccdddSQL> select translate('aaaabbbcccddd','b','e') from dual;TRANSLATE('AAAABBBCCCDDD','B',
------------------------------
aaaaeeecccdddSQL> select substr('aaaabbbcccddd',1,4) from dual;SUBSTR('AAAABBBCCCDDD',1,4)
---------------------------
aaaa