substr的用法

Question

这样可能不行 应该是 set address = substr(address,1,23) || '22'||substr(address,25)
        where id='11'

Answer 1

是这样吗,
 set address = substr(address,1,23) || '22'||substr(address,25,30)
        where substr(id,3,5)='12'

Answer 2

set address = substr(address,1,23) || '22'||substr(address,26)
        where substr(id,3,5)='12'

Answer 3

可以拉,多谢各位,可如果我想用一个变量代替'22'和'12',我就把他们换成变量吗/set address = substr(address,1,23) || aa||substr(address,26)
        where substr(id,3,5)=bb

Answer 4

你要用变量 就要写PL/SQL块啊

Answer 5

set address = substr(address,1,23) || '&aa'||substr(address,26)
        where substr(id,3,5)=bb

Answer 6

用replace 
SQL> SELECT REPLACE('I LOVE ORACLE','I','U') FROM DUAL;REPLACE('ILOV
-------------
U LOVE ORACLE選取了 1 列目前歷時: 00:00:00.31

Answer 7

declare
aa varchar2(10);
begin
aa:='11';
set address = substr(address,1,23) || aa||substr(address,26)
        where substr(id,3,5)=bb
end;