如下例子:
select substr('LL$$BOAT$$he很帅',1,instr('LL$$BOAT$$he很帅', '$$', 1, 1) – 1),substr('LL$$BOAT$$he很帅',instr('LL$$BOAT$$he很帅', '$$', 1, 1) + 2,instr('LL$$BOAT$$he很帅', '$$', 1, 2) – 2 -instr('LL$$BOAT$$he很帅', '$$', 1, 1)),substr('LL$$BOAT$$he很帅', instr('LL$$BOAT$$he很帅', '$$', 1, 2) + 2) from dual t;
,如果说,罗马是一座厚重和凝固的堡垒,