Oracle 18c

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

create table dummy_records (dummy_id int, dummy_value number)
insert into dummy_records (dummy_id, dummy_value)
     with cte(n) as (
            select 1 as n
            from dual union all
            select n + 1
             from cte
            where n < 100
           )
     select n, dbms_random.value(1, 100)
     from cte
100 rows affected

select *
from dummy_records


DUMMY_ID
DUMMY_VALUE


1
16.91132295506968060564292200956775186819

2
94.74920707858237114025749973516036470492

3
78.72920102414632525793363883189976495867

4
8.31459098057584624347138523059475541539

5
77.28512490108985033284654685068272858887

6
72.69205434952775890797069248573644336273

7
13.96214433586740621578073386930427591442

8
38.95392301179796412703657547775496643402

9
77.67836417852201376917673206292360003106

10
30.94284519214032114603197522656190367085

11
1.07611165348015967699764011162008535667

12
40.3502529018373389296080337245743643537

13
98.29531594618087290970838735484517234087

14
18.34512354602500743567762452018223123943

15
5.51733565307160352331825081077306179601

16
96.4296401261765618203712631993838241143

17
61.34629073355838055164708327101934915432

18
97.50380057823406004204805282383764933897

19
85.42633309748732036056174631389826398369

20
14.03325569129548219478652463231078269091

21
98.66383902320726512278665325552567857581

22
63.10434257872156468329841785038376005353

23
9.16894756713802568391326088722707998562

24
16.15453372121914046785520699469641175301

25
78.52119197291866823285761043429015662285

26
78.02356119760220206866042380463227644723

27
48.42343341033051904090796218319852161123

28
6.76550168868667724178692096839500348868

29
21.22538827584961949430425444138924557696

30
86.51704821084188523110208931297927099111

31
52.25706457881725473498925640973408569139

32
85.15395541651784235979632558271266521017

33
37.1699859668558822075453991931981542862

34
53.19595628854871195044767897767348704792

35
86.31860788569037383491565598545549900286

36
31.52581815252655898070286099156284272176

37
43.83122422990512582673067603841916277728

38
38.31379673576977408661555748917684053078

39
44.93458238678833143903493471131853851508

40
5.73529169998083728767936221258399408106

41
89.75453259575541603859790052248880797998

42
69.46318444626172573506847231187156177797

43
64.7517741773150432915615249082590890159

44
71.70775809217822099452661817837219121628

45
43.33916424357854128341337157189119743832

46
91.50586691288244501199119183387829844362

47
12.99735329293256661196648471081879629157

48
43.90302586534523187344859141201579004486

49
85.74457829959233047558396830064814557785

50
18.49233506271448284477655014408658294141

51
15.01329198545815431584440896538909127995

52
75.72939543106876721917375083643618014022

53
72.29688588697451252125334931661219517944

54
47.05148094346845612849719448059999133403

55
57.9924965608792396570002470599325210797

56
94.43251492798834883850053244385790849104

57
72.77276827618457320891792353979264115215

58
27.1526344344768442988416010150982865699

59
14.08009266926252348525830619898975890407

60
97.51051317693946982715080129207197416583

61
59.20910256036964413907278179871571435384

62
65.21920891468466095076999027903836160581

63
24.10787842831580648683290106046763164419

64
14.84835014537789597672213125612175431726

65
83.13880148068903309647965420423539071877

66
86.39471953917053351191329609707558435953

67
70.87607105436389791031089471613720707546

68
42.12654017608599873643906339326433511815

69
55.65892028179478152229318200935907177021

70
49.45191803985993496235318552209160031109

71
2.16493182615739910805062541196781819536

72
51.1008233293137965902449837935081571343

73
66.96698502449578577711652513570921111694

74
50.17810727480236365212327122215735299959

75
84.74101378347370318931314281068297390719

76
42.00300326678580640620002482741687601413

77
54.61020949160400969528960968426205849715

78
21.16630086007059229587974559804587627719

79
59.05755958656437234130379840671220179787

80
64.2657702725109987084415787349383022007

81
95.51589626031668491343697394871885938864

82
62.43672539578867335675237114858761289118

83
81.4948971197554444609606718048311836289

84
92.5222741628241320155576037580014407564

85
33.56852915431034135959928379357926232514

86
10.24956113969649439198950346966660677109

87
79.58647034450619119829685802657057370121

88
9.94275424304045541646332273299079543835

89
79.34859072302555624928927999277177361782

90
99.39870055495289732017396218444525790693

91
29.03633132946602880785366228363481688759

92
3.04032679027476996580345783713487713112

93
3.53300565045443503738554776821520213659

94
68.04246081510413792586783577178617015927

95
19.58364184535873326440149346870574839832

96
72.89333407644444913507755472672419869875

97
55.8579039854322592469817684089471461375

98
35.62784523167894120187241962439629609136

99
13.83429826826421973096568157163652633443

100
97.99808452537332280570655358125026920853

DUMMY_ID	DUMMY_VALUE
1	16.91132295506968060564292200956775186819
2	94.74920707858237114025749973516036470492
3	78.72920102414632525793363883189976495867
4	8.31459098057584624347138523059475541539
5	77.28512490108985033284654685068272858887
6	72.69205434952775890797069248573644336273
7	13.96214433586740621578073386930427591442
8	38.95392301179796412703657547775496643402
9	77.67836417852201376917673206292360003106
10	30.94284519214032114603197522656190367085
11	1.07611165348015967699764011162008535667
12	40.3502529018373389296080337245743643537
13	98.29531594618087290970838735484517234087
14	18.34512354602500743567762452018223123943
15	5.51733565307160352331825081077306179601
16	96.4296401261765618203712631993838241143
17	61.34629073355838055164708327101934915432
18	97.50380057823406004204805282383764933897
19	85.42633309748732036056174631389826398369
20	14.03325569129548219478652463231078269091
21	98.66383902320726512278665325552567857581
22	63.10434257872156468329841785038376005353
23	9.16894756713802568391326088722707998562
24	16.15453372121914046785520699469641175301
25	78.52119197291866823285761043429015662285
26	78.02356119760220206866042380463227644723
27	48.42343341033051904090796218319852161123
28	6.76550168868667724178692096839500348868
29	21.22538827584961949430425444138924557696
30	86.51704821084188523110208931297927099111
31	52.25706457881725473498925640973408569139
32	85.15395541651784235979632558271266521017
33	37.1699859668558822075453991931981542862
34	53.19595628854871195044767897767348704792
35	86.31860788569037383491565598545549900286
36	31.52581815252655898070286099156284272176
37	43.83122422990512582673067603841916277728
38	38.31379673576977408661555748917684053078
39	44.93458238678833143903493471131853851508
40	5.73529169998083728767936221258399408106
41	89.75453259575541603859790052248880797998
42	69.46318444626172573506847231187156177797
43	64.7517741773150432915615249082590890159
44	71.70775809217822099452661817837219121628
45	43.33916424357854128341337157189119743832
46	91.50586691288244501199119183387829844362
47	12.99735329293256661196648471081879629157
48	43.90302586534523187344859141201579004486
49	85.74457829959233047558396830064814557785
50	18.49233506271448284477655014408658294141
51	15.01329198545815431584440896538909127995
52	75.72939543106876721917375083643618014022
53	72.29688588697451252125334931661219517944
54	47.05148094346845612849719448059999133403
55	57.9924965608792396570002470599325210797
56	94.43251492798834883850053244385790849104
57	72.77276827618457320891792353979264115215
58	27.1526344344768442988416010150982865699
59	14.08009266926252348525830619898975890407
60	97.51051317693946982715080129207197416583
61	59.20910256036964413907278179871571435384
62	65.21920891468466095076999027903836160581
63	24.10787842831580648683290106046763164419
64	14.84835014537789597672213125612175431726
65	83.13880148068903309647965420423539071877
66	86.39471953917053351191329609707558435953
67	70.87607105436389791031089471613720707546
68	42.12654017608599873643906339326433511815
69	55.65892028179478152229318200935907177021
70	49.45191803985993496235318552209160031109
71	2.16493182615739910805062541196781819536
72	51.1008233293137965902449837935081571343
73	66.96698502449578577711652513570921111694
74	50.17810727480236365212327122215735299959
75	84.74101378347370318931314281068297390719
76	42.00300326678580640620002482741687601413
77	54.61020949160400969528960968426205849715
78	21.16630086007059229587974559804587627719
79	59.05755958656437234130379840671220179787
80	64.2657702725109987084415787349383022007
81	95.51589626031668491343697394871885938864
82	62.43672539578867335675237114858761289118
83	81.4948971197554444609606718048311836289
84	92.5222741628241320155576037580014407564
85	33.56852915431034135959928379357926232514
86	10.24956113969649439198950346966660677109
87	79.58647034450619119829685802657057370121
88	9.94275424304045541646332273299079543835
89	79.34859072302555624928927999277177361782
90	99.39870055495289732017396218444525790693
91	29.03633132946602880785366228363481688759
92	3.04032679027476996580345783713487713112
93	3.53300565045443503738554776821520213659
94	68.04246081510413792586783577178617015927
95	19.58364184535873326440149346870574839832
96	72.89333407644444913507755472672419869875
97	55.8579039854322592469817684089471461375
98	35.62784523167894120187241962439629609136
99	13.83429826826421973096568157163652633443
100	97.99808452537332280570655358125026920853