clear markdown feedback
clear markdown feedback
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; /
1 rows affected
 hidden batch(es)


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