How to use Oracle JSON_VALUE

I'm working on a trigger.

declare
  v_time number(11, 0);
begin
for i in 0..1
loop
  select JSON_VALUE(body, '$.sections[0].capsules[0].timer.seconds') into v_time from bodycontent where contentid=1081438;
dbms_output.put_line(v_time);
end loop;
end;

However, index references do not become dynamic.

like JSON_VALUE(body, '$.sections[i].capsules[i].timer.seconds')

Is there any way I can do this?

from Recent Questions - Stack Overflow https://ift.tt/3mtzHRo
https://ift.tt/eA8V8J