By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (40544 in the last week).
create table tab (name varchar2 (8), type varchar2 (8))
✓
hidden batch(es)
declare
type namelist is table of varchar2(8) index by pls_integer;
names namelist;
arr json_array_t := json_array_t ('["Stirfry", "Yogurt", "Apple"]');
begin
for idx in 1..arr.get_size loop
names(idx) := arr.get_string(idx-1);
end loop;
forall idx in indices of names
insert into tab (name, type) values (names(idx), 'TEXT');
end;
/
