select substr('[289]+[362]-[323]-12*[454]',
(select instr('[289]+[362]-[323]-12*[454]','[')+1 from dual),
(select
(select instr('[289]+[362]-[323]-12*[454]',']') from dual)-
(select instr('[289]+[362]-[323]-12*[454]','[')+1 from dual)
from dual)
) 指标ID from dual;
现在结果是 289
如何循环着得到 362 323 454
并且最终得到的结果格式为 289,362,323,454
谢谢了啊,急求啊
|