i want the below output logic in 10g datababse oracle has to be generic
Input will be '(123)(4(56)(78))'
output has to be like :
123
45678
56
78
(or)
for example i getting output in 11g for following
SELECT REGEXP_INSTR('1234567890', '(123)(4(56)(78))', 1, 1, 0, 'i', 3) FROM DUAL;
output : 5
i want the same kind of output in 10g