17,140
社区成员




--9i:
select substr(a, instr(a, '送') + 1, instr(a, '元') - instr(a, '送') - 1)
from (select '预存200送100元' a
from dual
union all
select '预存200送1000元' from dual);
--输出:
SUBSTR(A,INSTR(A,'ËÍ')+1,INSTR
100
1000
--10G:
select substr(regexp_substr('存1000话费送200元','送[[:digit:]]+'),2) from dual
select substr(a, instr(a, '送') + 1, instr(a, '元') - instr(a, '送') - 1)
from (select '预存200送100元' a
from dual
union all
select '预存200送1000元' from dual);
--输出:
SUBSTR(A,INSTR(A,'ËÍ')+1,INSTR
100
1000