Use LOOP to insert data to a table : Loop « PL SQL Statements « Oracle PL/SQL Tutorial

SQL>
SQL>
SQL>
SQL> -- create demo table
SQL> create table Employee(
  2    ID                 VARCHAR2(4 BYTE)         NOT NULL primary key,
  3    First_Name         VARCHAR2(10 BYTE),
  4    Last_Name          VARCHAR2(10 BYTE),
  5    Start_Date         DATE,
  6    End_Date           DATE,
  7    Salary             Number(8,2),
  8    City               VARCHAR2(10 BYTE),
  9    Description        VARCHAR2(15 BYTE)
 10  )
 11  /

Table created.

SQL>
SQL>
SQL> -- display data in the table
SQL> select * from Employee
  2  /

no rows selected

SQL>
SQL>
SQL>
SQL>
SQL> BEGIN
  2    FOR v_LoopCounter IN 1..50 LOOP
  3      INSERT INTO employee (id)
  4        VALUES (v_LoopCounter);
  5    END LOOP;
  6  END;
  7  /

PL/SQL procedure successfully completed.

SQL>
SQL> select * from employee;

ID   FIRST_NAME           LAST_NAME            START_DAT END_DATE      SALARY CITY       DESCRIPTION
---- -------------------- -------------------- --------- --------- ---------- ---------- ---------------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

50 rows selected.

SQL>
SQL>
SQL> -- clean the table
SQL> drop table Employee
  2  /

Table dropped.

SQL>
SQL>

22.3.Loop
	22.3.1.	Loops
	22.3.2.	Simple Loops
	22.3.3.	LOOP END LOOP
	22.3.4.	Count up by hundreds until we get an error
	22.3.5.	The EXIT WHEN statement can appear anywhere in the loop code.
	22.3.6.	Exit a LOOP
	22.3.7.	EXIT a LOOP for a certain condition
	22.3.8.	Nested loops: Loop inside of a Loop
	22.3.9.	Exiting from Nested Loops
	22.3.10.	Using Labels and EXIT Statements with Loops
	22.3.11.	Creating a REPEAT...UNTIL Loop
	22.3.12.	Use LOOP to insert data to a table
	22.3.13.	Fetch Cursor data in LOOP
	22.3.14.	A SQL Replacement for Regular Loops
	22.3.15.	Named loop block