clear markdown compare help best fiddles feedback
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805483 fiddles created (40779 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; /
1 rows affected
 hidden batch(es)

select * from tab
Stirfry TEXT
Yogurt TEXT
Apple TEXT
 hidden batch(es)