Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tab (name varchar2 (8), type varchar2 (8))
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

select * from tab


NAME
TYPE


Stirfry
TEXT

Yogurt
TEXT

Apple
TEXT