Generate 100 rows

View All Scripts Login to Run Script

Script Name Generate 100 rows
Description Simple script to fill a table with 100 rows
Area SQL General
Contributor Eric B.
Created Thursday September 01, 2016

Statement 1

create table aap (noot integer)

Table created.

Statement 2

insert into aap  
select level from dual connect by 1=1 and level <= 100

100 row(s) inserted.

Statement 3

select * from aap


NOOT
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100

100 rows selected.

Statement 4
```
drop table aap
```
```
Table dropped.
```

NOOT
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database