sql - 如何在 pl/sql 中编写遍历数字的循环

Question

我想写一个循环遍历数字 105 102 19 17 101 16 106 107
对于每次迭代，我想将数字插入查询并将其插入表中。

伪:

LOOP (105 102 19 17 101 16 106 107)
   FETCH select * from some_table where value=current_iteration_index --105..etc.
   INTO my_rec_type

END LOOP;

Answer 1

另一种方法:

declare
 type numListType is table of number;
 numList numListType;
begin
numList := numListType(
 105,102,19,17,101,16,106,107 
);
for i in numList.FIRST..numList.LAST loop
 -- your usage of element goes here
 dbms_output.put_line(numList(i));
end loop;
end;
/