Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF TZR';
create table t ( x int, y DATE, z TIMESTAMP WITH TIME ZONE );
DECLARE
  TYPE numlist IS TABLE OF NUMBER;
  TYPE datelist IS TABLE OF DATE;
  TYPE timestamplist IS TABLE OF TIMESTAMP WITH TIME ZONE;
  xs numlist       := numlist();
  ys datelist      := datelist();
  zs timestamplist := timestamplist();

  n     CONSTANT PLS_INTEGER              := 100;
  nowd  CONSTANT DATE                     := SYSDATE;
  nowts CONSTANT TIMESTAMP WITH TIME ZONE := SYSTIMESTAMP;
BEGIN
  xs.EXTEND(n);
  ys.EXTEND(n);
  zs.EXTEND(n);
  FOR i IN 1 .. n LOOP
    xs(i) := i;
    ys(i) := nowd + (i - 1) * INTERVAL '10' SECOND;
    zs(i) := nowts + (i - 1) * INTERVAL '10' SECOND;
  END LOOP;

  FORALL i IN 1 .. n
    INSERT INTO t (x, y, z) VALUES (xs(i), ys(i), zs(i));
END;
/
1 rows affected

SELECT * FROM t;


X
Y
Z


1
2022-05-13 16:03:10
2022-05-13 16:03:10.118561 +01:00

2
2022-05-13 16:03:20
2022-05-13 16:03:20.118561 +01:00

3
2022-05-13 16:03:30
2022-05-13 16:03:30.118561 +01:00

4
2022-05-13 16:03:40
2022-05-13 16:03:40.118561 +01:00

5
2022-05-13 16:03:50
2022-05-13 16:03:50.118561 +01:00

6
2022-05-13 16:04:00
2022-05-13 16:04:00.118561 +01:00

7
2022-05-13 16:04:10
2022-05-13 16:04:10.118561 +01:00

8
2022-05-13 16:04:20
2022-05-13 16:04:20.118561 +01:00

9
2022-05-13 16:04:30
2022-05-13 16:04:30.118561 +01:00

10
2022-05-13 16:04:40
2022-05-13 16:04:40.118561 +01:00

11
2022-05-13 16:04:50
2022-05-13 16:04:50.118561 +01:00

12
2022-05-13 16:05:00
2022-05-13 16:05:00.118561 +01:00

13
2022-05-13 16:05:10
2022-05-13 16:05:10.118561 +01:00

14
2022-05-13 16:05:20
2022-05-13 16:05:20.118561 +01:00

15
2022-05-13 16:05:30
2022-05-13 16:05:30.118561 +01:00

16
2022-05-13 16:05:40
2022-05-13 16:05:40.118561 +01:00

17
2022-05-13 16:05:50
2022-05-13 16:05:50.118561 +01:00

18
2022-05-13 16:06:00
2022-05-13 16:06:00.118561 +01:00

19
2022-05-13 16:06:10
2022-05-13 16:06:10.118561 +01:00

20
2022-05-13 16:06:20
2022-05-13 16:06:20.118561 +01:00

21
2022-05-13 16:06:30
2022-05-13 16:06:30.118561 +01:00

22
2022-05-13 16:06:40
2022-05-13 16:06:40.118561 +01:00

23
2022-05-13 16:06:50
2022-05-13 16:06:50.118561 +01:00

24
2022-05-13 16:07:00
2022-05-13 16:07:00.118561 +01:00

25
2022-05-13 16:07:10
2022-05-13 16:07:10.118561 +01:00

26
2022-05-13 16:07:20
2022-05-13 16:07:20.118561 +01:00

27
2022-05-13 16:07:30
2022-05-13 16:07:30.118561 +01:00

28
2022-05-13 16:07:40
2022-05-13 16:07:40.118561 +01:00

29
2022-05-13 16:07:50
2022-05-13 16:07:50.118561 +01:00

30
2022-05-13 16:08:00
2022-05-13 16:08:00.118561 +01:00

31
2022-05-13 16:08:10
2022-05-13 16:08:10.118561 +01:00

32
2022-05-13 16:08:20
2022-05-13 16:08:20.118561 +01:00

33
2022-05-13 16:08:30
2022-05-13 16:08:30.118561 +01:00

34
2022-05-13 16:08:40
2022-05-13 16:08:40.118561 +01:00

35
2022-05-13 16:08:50
2022-05-13 16:08:50.118561 +01:00

36
2022-05-13 16:09:00
2022-05-13 16:09:00.118561 +01:00

37
2022-05-13 16:09:10
2022-05-13 16:09:10.118561 +01:00

38
2022-05-13 16:09:20
2022-05-13 16:09:20.118561 +01:00

39
2022-05-13 16:09:30
2022-05-13 16:09:30.118561 +01:00

40
2022-05-13 16:09:40
2022-05-13 16:09:40.118561 +01:00

41
2022-05-13 16:09:50
2022-05-13 16:09:50.118561 +01:00

42
2022-05-13 16:10:00
2022-05-13 16:10:00.118561 +01:00

43
2022-05-13 16:10:10
2022-05-13 16:10:10.118561 +01:00

44
2022-05-13 16:10:20
2022-05-13 16:10:20.118561 +01:00

45
2022-05-13 16:10:30
2022-05-13 16:10:30.118561 +01:00

46
2022-05-13 16:10:40
2022-05-13 16:10:40.118561 +01:00

47
2022-05-13 16:10:50
2022-05-13 16:10:50.118561 +01:00

48
2022-05-13 16:11:00
2022-05-13 16:11:00.118561 +01:00

49
2022-05-13 16:11:10
2022-05-13 16:11:10.118561 +01:00

50
2022-05-13 16:11:20
2022-05-13 16:11:20.118561 +01:00

51
2022-05-13 16:11:30
2022-05-13 16:11:30.118561 +01:00

52
2022-05-13 16:11:40
2022-05-13 16:11:40.118561 +01:00

53
2022-05-13 16:11:50
2022-05-13 16:11:50.118561 +01:00

54
2022-05-13 16:12:00
2022-05-13 16:12:00.118561 +01:00

55
2022-05-13 16:12:10
2022-05-13 16:12:10.118561 +01:00

56
2022-05-13 16:12:20
2022-05-13 16:12:20.118561 +01:00

57
2022-05-13 16:12:30
2022-05-13 16:12:30.118561 +01:00

58
2022-05-13 16:12:40
2022-05-13 16:12:40.118561 +01:00

59
2022-05-13 16:12:50
2022-05-13 16:12:50.118561 +01:00

60
2022-05-13 16:13:00
2022-05-13 16:13:00.118561 +01:00

61
2022-05-13 16:13:10
2022-05-13 16:13:10.118561 +01:00

62
2022-05-13 16:13:20
2022-05-13 16:13:20.118561 +01:00

63
2022-05-13 16:13:30
2022-05-13 16:13:30.118561 +01:00

64
2022-05-13 16:13:40
2022-05-13 16:13:40.118561 +01:00

65
2022-05-13 16:13:50
2022-05-13 16:13:50.118561 +01:00

66
2022-05-13 16:14:00
2022-05-13 16:14:00.118561 +01:00

67
2022-05-13 16:14:10
2022-05-13 16:14:10.118561 +01:00

68
2022-05-13 16:14:20
2022-05-13 16:14:20.118561 +01:00

69
2022-05-13 16:14:30
2022-05-13 16:14:30.118561 +01:00

70
2022-05-13 16:14:40
2022-05-13 16:14:40.118561 +01:00

71
2022-05-13 16:14:50
2022-05-13 16:14:50.118561 +01:00

72
2022-05-13 16:15:00
2022-05-13 16:15:00.118561 +01:00

73
2022-05-13 16:15:10
2022-05-13 16:15:10.118561 +01:00

74
2022-05-13 16:15:20
2022-05-13 16:15:20.118561 +01:00

75
2022-05-13 16:15:30
2022-05-13 16:15:30.118561 +01:00

76
2022-05-13 16:15:40
2022-05-13 16:15:40.118561 +01:00

77
2022-05-13 16:15:50
2022-05-13 16:15:50.118561 +01:00

78
2022-05-13 16:16:00
2022-05-13 16:16:00.118561 +01:00

79
2022-05-13 16:16:10
2022-05-13 16:16:10.118561 +01:00

80
2022-05-13 16:16:20
2022-05-13 16:16:20.118561 +01:00

81
2022-05-13 16:16:30
2022-05-13 16:16:30.118561 +01:00

82
2022-05-13 16:16:40
2022-05-13 16:16:40.118561 +01:00

83
2022-05-13 16:16:50
2022-05-13 16:16:50.118561 +01:00

84
2022-05-13 16:17:00
2022-05-13 16:17:00.118561 +01:00

85
2022-05-13 16:17:10
2022-05-13 16:17:10.118561 +01:00

86
2022-05-13 16:17:20
2022-05-13 16:17:20.118561 +01:00

87
2022-05-13 16:17:30
2022-05-13 16:17:30.118561 +01:00

88
2022-05-13 16:17:40
2022-05-13 16:17:40.118561 +01:00

89
2022-05-13 16:17:50
2022-05-13 16:17:50.118561 +01:00

90
2022-05-13 16:18:00
2022-05-13 16:18:00.118561 +01:00

91
2022-05-13 16:18:10
2022-05-13 16:18:10.118561 +01:00

92
2022-05-13 16:18:20
2022-05-13 16:18:20.118561 +01:00

93
2022-05-13 16:18:30
2022-05-13 16:18:30.118561 +01:00

94
2022-05-13 16:18:40
2022-05-13 16:18:40.118561 +01:00

95
2022-05-13 16:18:50
2022-05-13 16:18:50.118561 +01:00

96
2022-05-13 16:19:00
2022-05-13 16:19:00.118561 +01:00

97
2022-05-13 16:19:10
2022-05-13 16:19:10.118561 +01:00

98
2022-05-13 16:19:20
2022-05-13 16:19:20.118561 +01:00

99
2022-05-13 16:19:30
2022-05-13 16:19:30.118561 +01:00

100
2022-05-13 16:19:40
2022-05-13 16:19:40.118561 +01:00

X	Y	Z
1	2022-05-13 16:03:10	2022-05-13 16:03:10.118561 +01:00
2	2022-05-13 16:03:20	2022-05-13 16:03:20.118561 +01:00
3	2022-05-13 16:03:30	2022-05-13 16:03:30.118561 +01:00
4	2022-05-13 16:03:40	2022-05-13 16:03:40.118561 +01:00
5	2022-05-13 16:03:50	2022-05-13 16:03:50.118561 +01:00
6	2022-05-13 16:04:00	2022-05-13 16:04:00.118561 +01:00
7	2022-05-13 16:04:10	2022-05-13 16:04:10.118561 +01:00
8	2022-05-13 16:04:20	2022-05-13 16:04:20.118561 +01:00
9	2022-05-13 16:04:30	2022-05-13 16:04:30.118561 +01:00
10	2022-05-13 16:04:40	2022-05-13 16:04:40.118561 +01:00
11	2022-05-13 16:04:50	2022-05-13 16:04:50.118561 +01:00
12	2022-05-13 16:05:00	2022-05-13 16:05:00.118561 +01:00
13	2022-05-13 16:05:10	2022-05-13 16:05:10.118561 +01:00
14	2022-05-13 16:05:20	2022-05-13 16:05:20.118561 +01:00
15	2022-05-13 16:05:30	2022-05-13 16:05:30.118561 +01:00
16	2022-05-13 16:05:40	2022-05-13 16:05:40.118561 +01:00
17	2022-05-13 16:05:50	2022-05-13 16:05:50.118561 +01:00
18	2022-05-13 16:06:00	2022-05-13 16:06:00.118561 +01:00
19	2022-05-13 16:06:10	2022-05-13 16:06:10.118561 +01:00
20	2022-05-13 16:06:20	2022-05-13 16:06:20.118561 +01:00
21	2022-05-13 16:06:30	2022-05-13 16:06:30.118561 +01:00
22	2022-05-13 16:06:40	2022-05-13 16:06:40.118561 +01:00
23	2022-05-13 16:06:50	2022-05-13 16:06:50.118561 +01:00
24	2022-05-13 16:07:00	2022-05-13 16:07:00.118561 +01:00
25	2022-05-13 16:07:10	2022-05-13 16:07:10.118561 +01:00
26	2022-05-13 16:07:20	2022-05-13 16:07:20.118561 +01:00
27	2022-05-13 16:07:30	2022-05-13 16:07:30.118561 +01:00
28	2022-05-13 16:07:40	2022-05-13 16:07:40.118561 +01:00
29	2022-05-13 16:07:50	2022-05-13 16:07:50.118561 +01:00
30	2022-05-13 16:08:00	2022-05-13 16:08:00.118561 +01:00
31	2022-05-13 16:08:10	2022-05-13 16:08:10.118561 +01:00
32	2022-05-13 16:08:20	2022-05-13 16:08:20.118561 +01:00
33	2022-05-13 16:08:30	2022-05-13 16:08:30.118561 +01:00
34	2022-05-13 16:08:40	2022-05-13 16:08:40.118561 +01:00
35	2022-05-13 16:08:50	2022-05-13 16:08:50.118561 +01:00
36	2022-05-13 16:09:00	2022-05-13 16:09:00.118561 +01:00
37	2022-05-13 16:09:10	2022-05-13 16:09:10.118561 +01:00
38	2022-05-13 16:09:20	2022-05-13 16:09:20.118561 +01:00
39	2022-05-13 16:09:30	2022-05-13 16:09:30.118561 +01:00
40	2022-05-13 16:09:40	2022-05-13 16:09:40.118561 +01:00
41	2022-05-13 16:09:50	2022-05-13 16:09:50.118561 +01:00
42	2022-05-13 16:10:00	2022-05-13 16:10:00.118561 +01:00
43	2022-05-13 16:10:10	2022-05-13 16:10:10.118561 +01:00
44	2022-05-13 16:10:20	2022-05-13 16:10:20.118561 +01:00
45	2022-05-13 16:10:30	2022-05-13 16:10:30.118561 +01:00
46	2022-05-13 16:10:40	2022-05-13 16:10:40.118561 +01:00
47	2022-05-13 16:10:50	2022-05-13 16:10:50.118561 +01:00
48	2022-05-13 16:11:00	2022-05-13 16:11:00.118561 +01:00
49	2022-05-13 16:11:10	2022-05-13 16:11:10.118561 +01:00
50	2022-05-13 16:11:20	2022-05-13 16:11:20.118561 +01:00
51	2022-05-13 16:11:30	2022-05-13 16:11:30.118561 +01:00
52	2022-05-13 16:11:40	2022-05-13 16:11:40.118561 +01:00
53	2022-05-13 16:11:50	2022-05-13 16:11:50.118561 +01:00
54	2022-05-13 16:12:00	2022-05-13 16:12:00.118561 +01:00
55	2022-05-13 16:12:10	2022-05-13 16:12:10.118561 +01:00
56	2022-05-13 16:12:20	2022-05-13 16:12:20.118561 +01:00
57	2022-05-13 16:12:30	2022-05-13 16:12:30.118561 +01:00
58	2022-05-13 16:12:40	2022-05-13 16:12:40.118561 +01:00
59	2022-05-13 16:12:50	2022-05-13 16:12:50.118561 +01:00
60	2022-05-13 16:13:00	2022-05-13 16:13:00.118561 +01:00
61	2022-05-13 16:13:10	2022-05-13 16:13:10.118561 +01:00
62	2022-05-13 16:13:20	2022-05-13 16:13:20.118561 +01:00
63	2022-05-13 16:13:30	2022-05-13 16:13:30.118561 +01:00
64	2022-05-13 16:13:40	2022-05-13 16:13:40.118561 +01:00
65	2022-05-13 16:13:50	2022-05-13 16:13:50.118561 +01:00
66	2022-05-13 16:14:00	2022-05-13 16:14:00.118561 +01:00
67	2022-05-13 16:14:10	2022-05-13 16:14:10.118561 +01:00
68	2022-05-13 16:14:20	2022-05-13 16:14:20.118561 +01:00
69	2022-05-13 16:14:30	2022-05-13 16:14:30.118561 +01:00
70	2022-05-13 16:14:40	2022-05-13 16:14:40.118561 +01:00
71	2022-05-13 16:14:50	2022-05-13 16:14:50.118561 +01:00
72	2022-05-13 16:15:00	2022-05-13 16:15:00.118561 +01:00
73	2022-05-13 16:15:10	2022-05-13 16:15:10.118561 +01:00
74	2022-05-13 16:15:20	2022-05-13 16:15:20.118561 +01:00
75	2022-05-13 16:15:30	2022-05-13 16:15:30.118561 +01:00
76	2022-05-13 16:15:40	2022-05-13 16:15:40.118561 +01:00
77	2022-05-13 16:15:50	2022-05-13 16:15:50.118561 +01:00
78	2022-05-13 16:16:00	2022-05-13 16:16:00.118561 +01:00
79	2022-05-13 16:16:10	2022-05-13 16:16:10.118561 +01:00
80	2022-05-13 16:16:20	2022-05-13 16:16:20.118561 +01:00
81	2022-05-13 16:16:30	2022-05-13 16:16:30.118561 +01:00
82	2022-05-13 16:16:40	2022-05-13 16:16:40.118561 +01:00
83	2022-05-13 16:16:50	2022-05-13 16:16:50.118561 +01:00
84	2022-05-13 16:17:00	2022-05-13 16:17:00.118561 +01:00
85	2022-05-13 16:17:10	2022-05-13 16:17:10.118561 +01:00
86	2022-05-13 16:17:20	2022-05-13 16:17:20.118561 +01:00
87	2022-05-13 16:17:30	2022-05-13 16:17:30.118561 +01:00
88	2022-05-13 16:17:40	2022-05-13 16:17:40.118561 +01:00
89	2022-05-13 16:17:50	2022-05-13 16:17:50.118561 +01:00
90	2022-05-13 16:18:00	2022-05-13 16:18:00.118561 +01:00
91	2022-05-13 16:18:10	2022-05-13 16:18:10.118561 +01:00
92	2022-05-13 16:18:20	2022-05-13 16:18:20.118561 +01:00
93	2022-05-13 16:18:30	2022-05-13 16:18:30.118561 +01:00
94	2022-05-13 16:18:40	2022-05-13 16:18:40.118561 +01:00
95	2022-05-13 16:18:50	2022-05-13 16:18:50.118561 +01:00
96	2022-05-13 16:19:00	2022-05-13 16:19:00.118561 +01:00
97	2022-05-13 16:19:10	2022-05-13 16:19:10.118561 +01:00
98	2022-05-13 16:19:20	2022-05-13 16:19:20.118561 +01:00
99	2022-05-13 16:19:30	2022-05-13 16:19:30.118561 +01:00
100	2022-05-13 16:19:40	2022-05-13 16:19:40.118561 +01:00