Oracle syntax memo cycle

Oracle syntax memo loop oracle loop statement loop while for test use table SQL code create table hadoop_param (name varchar2 (255), num int) www.2cto.com SQL code declare v_name varchar2 (255 ); v_num int; v_pos int; begin v_pos: = 0; loop exit when v_pos = 1000; v_pos: = v_pos + 1; v_name: = 'name' | v_pos; v_num: = v_pos; insert into hadoop_param values (v_name, v_num); end loop; commit; end; declare v_name varchar2 (255); v_num int; v_pos int; begin v_pos: = 1; while v_pos <= 1000 loop v_pos: = v_pos + 1; v_name: = 'name' | v_pos; v_num: = v_pos; insert into hadoop_param values (v_name, v_num ); end loop; commit; end; declare v_name varchar2 (255); v_num int; v_pos int; begin v_pos: = 1; for v_pos in 1 .. 1000 loop v_name: = 'name' | v_pos; v_num: = v_pos; insert into hadoop_param values (v_name, v_num); end loop; commit; end;