Oralce 字符串截取

update E_SYS_STRATEGY set sconfigvalue=(select Substr((select sconfigvalue from E_SYS_STRATEGY where nseqnum=11), 1,
(Select INSTR((select sconfigvalue from E_SYS_STRATEGY where nseqnum=11),':',6,1) from dual)) from dual)||'28080/UC/portal/login.action' where nseqnum=11;

update E_SYS_STRATEGY set sconfigvalue=(select Substr((select sconfigvalue from E_SYS_STRATEGY where nseqnum=12), 1,
(Select INSTR((select sconfigvalue from E_SYS_STRATEGY where nseqnum=12),':',6,1) from dual)) from dual)||'28080/UC/portal/login.action' where nseqnum=12;

update E_SYS_STRATEGY set sconfigvalue=(select Substr((select sconfigvalue from E_SYS_STRATEGY where nseqnum=11), 8,
(Select INSTR((select sconfigvalue from E_SYS_STRATEGY where nseqnum=11),':',6,1) from dual)-7) from dual)||'8086' where nseqnum=19;