Learn PL/SQL
1. How to use array(temp array)
create table test_caseid (caseid RAW(16), userid NUMBER(9,0), activeflag NUMBER(9,0) DEFAULT 0);
declare
type array_t is varray(13) of NUMBER;
--temp table or create a table then sue cursor
array array_t := array_t(116,113,47,108,112,117,110,107,114,109,115,111,106);
v_guid varchar2(40);
begin
for j in 1..9 loop
-- for cout
v_guid := sys_guid();
--get caseid guid
for i in 1..array.count
--get userid number
loop
--dbms_output.put_line(array(i));
insert into test_caseid(caseid, userid) values (v_guid, array(i));
end loop;
commit;
end loop;
end;