sys@TASCII>select substr('123456789',0,2)|| &l_cahr ||substr('123456789',4) from
dual;
输入 l_cahr 的值: 's'
原值 1: select substr('123456789',0,2)|| &l_cahr ||substr('123456789',4) from
dual
新值 1: select substr('123456789',0,2)|| 's' ||substr('123456789',4) from dua
lSUBSTR('1
---------
12s456789
dual;
输入 l_cahr 的值: 's'
原值 1: select substr('123456789',0,2)|| &l_cahr ||substr('123456789',4) from
dual
新值 1: select substr('123456789',0,2)|| 's' ||substr('123456789',4) from dua
lSUBSTR('1
---------
12s456789
不能满足需要么?
不过还是谢谢这位老兄.