By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE SEQUENCE seq;
create table t(id INT, rowname VARCHAR2(20));
DECLARE
TYPE ctype
IS TABLE OF t%ROWTYPE;
ct CTYPE;
BEGIN
SELECT seq.NEXTVAL AS id,
'ROW'
||LEVEL AS rowname
bulk collect INTO ct
FROM dual
CONNECT BY LEVEL <= 100;
forall i IN ct.first..ct.last
INSERT INTO t
VALUES Ct(i);
END;
/
1 rows affected
select * FROM t;
| ID | ROWNAME |
|---|---|
| 1 | ROW1 |
| 2 | ROW2 |
| 3 | ROW3 |
| 4 | ROW4 |
| 5 | ROW5 |
| 6 | ROW6 |
| 7 | ROW7 |
| 8 | ROW8 |
| 9 | ROW9 |
| 10 | ROW10 |
| 11 | ROW11 |
| 12 | ROW12 |
| 13 | ROW13 |
| 14 | ROW14 |
| 15 | ROW15 |
| 16 | ROW16 |
| 17 | ROW17 |
| 18 | ROW18 |
| 19 | ROW19 |
| 20 | ROW20 |
| 21 | ROW21 |
| 22 | ROW22 |
| 23 | ROW23 |
| 24 | ROW24 |
| 25 | ROW25 |
| 26 | ROW26 |
| 27 | ROW27 |
| 28 | ROW28 |
| 29 | ROW29 |
| 30 | ROW30 |
| 31 | ROW31 |
| 32 | ROW32 |
| 33 | ROW33 |
| 34 | ROW34 |
| 35 | ROW35 |
| 36 | ROW36 |
| 37 | ROW37 |
| 38 | ROW38 |
| 39 | ROW39 |
| 40 | ROW40 |
| 41 | ROW41 |
| 42 | ROW42 |
| 43 | ROW43 |
| 44 | ROW44 |
| 45 | ROW45 |
| 46 | ROW46 |
| 47 | ROW47 |
| 48 | ROW48 |
| 49 | ROW49 |
| 50 | ROW50 |
| 51 | ROW51 |
| 52 | ROW52 |
| 53 | ROW53 |
| 54 | ROW54 |
| 55 | ROW55 |
| 56 | ROW56 |
| 57 | ROW57 |
| 58 | ROW58 |
| 59 | ROW59 |
| 60 | ROW60 |
| 61 | ROW61 |
| 62 | ROW62 |
| 63 | ROW63 |
| 64 | ROW64 |
| 65 | ROW65 |
| 66 | ROW66 |
| 67 | ROW67 |
| 68 | ROW68 |
| 69 | ROW69 |
| 70 | ROW70 |
| 71 | ROW71 |
| 72 | ROW72 |
| 73 | ROW73 |
| 74 | ROW74 |
| 75 | ROW75 |
| 76 | ROW76 |
| 77 | ROW77 |
| 78 | ROW78 |
| 79 | ROW79 |
| 80 | ROW80 |
| 81 | ROW81 |
| 82 | ROW82 |
| 83 | ROW83 |
| 84 | ROW84 |
| 85 | ROW85 |
| 86 | ROW86 |
| 87 | ROW87 |
| 88 | ROW88 |
| 89 | ROW89 |
| 90 | ROW90 |
| 91 | ROW91 |
| 92 | ROW92 |
| 93 | ROW93 |
| 94 | ROW94 |
| 95 | ROW95 |
| 96 | ROW96 |
| 97 | ROW97 |
| 98 | ROW98 |
| 99 | ROW99 |
| 100 | ROW100 |