add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with cte as (
select 1 as road_id, 2 as num_vertices from dual
union all
select 2 as road_id, null as num_vertices from dual
union all
select 3 as road_id, 1000 as num_vertices from dual
),
numbers as (select level as vertex from dual connect by level <= (select max(cte.num_vertices) from cte ))
select
*
from
cte
cross join
numbers
where
vertex <= num_vertices
order by
road_id,
vertex
ROAD_ID NUM_VERTICES VERTEX
1 2 1
1 2 2
3 1000 1
3 1000 2
3 1000 3
3 1000 4
3 1000 5
3 1000 6
3 1000 7
3 1000 8
3 1000 9
3 1000 10
3 1000 11
3 1000 12
3 1000 13
3 1000 14
3 1000 15
3 1000 16
3 1000 17
3 1000 18
3 1000 19
3 1000 20
3 1000 21
3 1000 22
3 1000 23
3 1000 24
3 1000 25
3 1000 26
3 1000 27
3 1000 28
3 1000 29
3 1000 30
3 1000 31
3 1000 32
3 1000 33
3 1000 34
3 1000 35
3 1000 36
3 1000 37
3 1000 38
3 1000 39
3 1000 40
3 1000 41
3 1000 42
3 1000 43
3 1000 44
3 1000 45
3 1000 46
3 1000 47
3 1000 48
3 1000 49
3 1000 50
3 1000 51
3 1000 52
3 1000 53
3 1000 54
3 1000 55
3 1000 56
3 1000 57
3 1000 58
3 1000 59
3 1000 60
3 1000 61
3 1000 62
3 1000 63
3 1000 64
3 1000 65
3 1000 66
3 1000 67
3 1000 68
3 1000 69
3 1000 70
3 1000 71
3 1000 72
3 1000 73
3 1000 74
3 1000 75
3 1000 76
3 1000 77
3 1000 78
3 1000 79
3 1000 80
3 1000 81
3 1000 82
3 1000 83
3 1000 84
3 1000 85
3 1000 86
3 1000 87
3 1000 88
3 1000 89
3 1000 90
3 1000 91
3 1000 92
3 1000 93
3 1000 94
3 1000 95
3 1000 96
3 1000 97
3 1000 98
3 1000 99
3 1000 100
3 1000 101
3 1000 102
3 1000 103
3 1000 104
3 1000 105
3 1000 106
3 1000 107
3 1000 108
3 1000 109
3 1000 110
3 1000 111
3 1000 112
3 1000 113
3 1000 114
3 1000 115
3 1000 116
3 1000 117
3 1000 118
3 1000 119
3 1000 120
3 1000 121
3 1000 122
3 1000 123
3 1000 124
3 1000 125
3 1000 126
3 1000 127
3 1000 128
3 1000 129
3 1000 130
3 1000 131
3 1000 132
3 1000 133
3 1000 134
3 1000 135
3 1000 136
3 1000 137
3 1000 138
3 1000 139
3 1000 140
3 1000 141
3 1000 142
3 1000 143
3 1000 144
3 1000 145
3 1000 146
3 1000 147
3 1000 148
3 1000 149
3 1000 150
3 1000 151
3 1000 152
3 1000 153
3 1000 154
3 1000 155
3 1000 156
3 1000 157
3 1000 158
3 1000 159
3 1000 160
3 1000 161
3 1000 162
3 1000 163
3 1000 164
3 1000 165
3 1000 166
3 1000 167
3 1000 168
3 1000 169
3 1000 170
3 1000 171
3 1000 172
3 1000 173
3 1000 174
3 1000 175
3 1000 176
3 1000 177
3 1000 178
3 1000 179
3 1000 180
3 1000 181
3 1000 182
3 1000 183
3 1000 184
3 1000 185
3 1000 186
3 1000 187
3 1000 188
3 1000 189
3 1000 190
3 1000 191
3 1000 192
3 1000 193
3 1000 194
3 1000 195
3 1000 196
3 1000 197
3 1000 198
3 1000 199
3 1000 200
3 1000 201
3 1000 202
3 1000 203
3 1000 204
3 1000 205
3 1000 206
3 1000 207
3 1000 208
3 1000 209
3 1000 210
3 1000 211
3 1000 212
3 1000 213
3 1000 214
3 1000 215
3 1000 216
3 1000 217
3 1000 218
3 1000 219
3 1000 220
3 1000 221
3 1000 222
3 1000 223
3 1000 224
3 1000 225
3 1000 226
3 1000 227
3 1000 228
3 1000 229
3 1000 230
3 1000 231
3 1000 232
3 1000 233
3 1000 234
3 1000 235
3 1000 236
3 1000 237
3 1000 238
3 1000 239
3 1000 240
3 1000 241
3 1000 242
3 1000 243
3 1000 244
3 1000 245
3 1000 246
3 1000 247
3 1000 248
3 1000 249
3 1000 250
3 1000 251
3 1000 252
3 1000 253
3 1000 254
3 1000 255
3 1000 256
3 1000 257
3 1000 258
3 1000 259
3 1000 260
3 1000 261
3 1000 262
3 1000 263
3 1000 264
3 1000 265
3 1000 266
3 1000 267
3 1000 268
3 1000 269
3 1000 270
3 1000 271
3 1000 272
3 1000 273
3 1000 274
3 1000 275
3 1000 276
3 1000 277
3 1000 278
3 1000 279
3 1000 280
3 1000 281
3 1000 282
3 1000 283
3 1000 284
3 1000 285
3 1000 286
3 1000 287
3 1000 288
3 1000 289
3 1000 290
3 1000 291
3 1000 292
3 1000 293
3 1000 294
3 1000 295
3 1000 296
3 1000 297
3 1000 298
3 1000 299
3 1000 300
3 1000 301
3 1000 302
3 1000 303
3 1000 304
3 1000 305
3 1000 306
3 1000 307
3 1000 308
3 1000 309
3 1000 310
3 1000 311
3 1000 312
3 1000 313
3 1000 314
3 1000 315
3 1000 316
3 1000 317
3 1000 318
3 1000 319
3 1000 320
3 1000 321
3 1000 322
3 1000 323
3 1000 324
3 1000 325
3 1000 326
3 1000 327
3 1000 328
3 1000 329
3 1000 330
3 1000 331
3 1000 332
3 1000 333
3 1000 334
3 1000 335
3 1000 336
3 1000 337
3 1000 338
3 1000 339
3 1000 340
3 1000 341
3 1000 342
3 1000 343
3 1000 344
3 1000 345
3 1000 346
3 1000 347
3 1000 348
3 1000 349
3 1000 350
3 1000 351
3 1000 352
3 1000 353
3 1000 354
3 1000 355
3 1000 356
3 1000 357
3 1000 358
3 1000 359
3 1000 360
3 1000 361
3 1000 362
3 1000 363
3 1000 364
3 1000 365
3 1000 366
3 1000 367
3 1000 368
3 1000 369
3 1000 370
3 1000 371
3 1000 372
3 1000 373
3 1000 374
3 1000 375
3 1000 376
3 1000 377
3 1000 378
3 1000 379
3 1000 380
3 1000 381
3 1000 382
3 1000 383
3 1000 384
3 1000 385
3 1000 386
3 1000 387
3 1000 388
3 1000 389
3 1000 390
3 1000 391
3 1000 392
3 1000 393
3 1000 394
3 1000 395
3 1000 396
3 1000 397
3 1000 398
3 1000 399
3 1000 400
3 1000 401
3 1000 402
3 1000 403
3 1000 404
3 1000 405
3 1000 406
3 1000 407
3 1000 408
3 1000 409
3 1000 410
3 1000 411
3 1000 412
3 1000 413
3 1000 414
3 1000 415
3 1000 416
3 1000 417
3 1000 418
3 1000 419
3 1000 420
3 1000 421
3 1000 422
3 1000 423
3 1000 424
3 1000 425
3 1000 426
3 1000 427
3 1000 428
3 1000 429
3 1000 430
3 1000 431
3 1000 432
3 1000 433
3 1000 434
3 1000 435
3 1000 436
3 1000 437
3 1000 438
3 1000 439
3 1000 440
3 1000 441
3 1000 442
3 1000 443
3 1000 444
3 1000 445
3 1000 446
3 1000 447
3 1000 448
3 1000 449
3 1000 450
3 1000 451
3 1000 452
3 1000 453
3 1000 454
3 1000 455
3 1000 456
3 1000 457
3 1000 458
3 1000 459
3 1000 460
3 1000 461
3 1000 462
3 1000 463
3 1000 464
3 1000 465
3 1000 466
3 1000 467
3 1000 468
3 1000 469
3 1000 470
3 1000 471
3 1000 472
3 1000 473
3 1000 474
3 1000 475
3 1000 476
3 1000 477
3 1000 478
3 1000 479
3 1000 480
3 1000 481
3 1000 482
3 1000 483
3 1000 484
3 1000 485
3 1000 486
3 1000 487
3 1000 488
3 1000 489
3 1000 490
3 1000 491
3 1000 492
3 1000 493
3 1000 494
3 1000 495
3 1000 496
3 1000 497
3 1000 498
3 1000 499
3 1000 500
3 1000 501
3 1000 502
3 1000 503
3 1000 504
3 1000 505
3 1000 506
3 1000 507
3 1000 508
3 1000 509
3 1000 510
3 1000 511
3 1000 512
3 1000 513
3 1000 514
3 1000 515
3 1000 516
3 1000 517
3 1000 518
3 1000 519
3 1000 520
3 1000 521
3 1000 522
3 1000 523
3 1000 524
3 1000 525
3 1000 526
3 1000 527
3 1000 528
3 1000 529
3 1000 530
3 1000 531
3 1000 532
3 1000 533
3 1000 534
3 1000 535
3 1000 536
3 1000 537
3 1000 538
3 1000 539
3 1000 540
3 1000 541
3 1000 542
3 1000 543
3 1000 544
3 1000 545
3 1000 546
3 1000 547
3 1000 548
3 1000 549
3 1000 550
3 1000 551
3 1000 552
3 1000 553
3 1000 554
3 1000 555
3 1000 556
3 1000 557
3 1000 558
3 1000 559
3 1000 560
3 1000 561
3 1000 562
3 1000 563
3 1000 564
3 1000 565
3 1000 566
3 1000 567
3 1000 568
3 1000 569
3 1000 570
3 1000 571
3 1000 572
3 1000 573
3 1000 574
3 1000 575
3 1000 576
3 1000 577
3 1000 578
3 1000 579
3 1000 580
3 1000 581
3 1000 582
3 1000 583
3 1000 584
3 1000 585
3 1000 586
3 1000 587
3 1000 588
3 1000 589
3 1000 590
3 1000 591
3 1000 592
3 1000 593
3 1000 594
3 1000 595
3 1000 596
3 1000 597
3 1000 598
3 1000 599
3 1000 600
3 1000 601
3 1000 602
3 1000 603
3 1000 604
3 1000 605
3 1000 606
3 1000 607
3 1000 608
3 1000 609
3 1000 610
3 1000 611
3 1000 612
3 1000 613
3 1000 614
3 1000 615
3 1000 616
3 1000 617
3 1000 618
3 1000 619
3 1000 620
3 1000 621
3 1000 622
3 1000 623
3 1000 624
3 1000 625
3 1000 626
3 1000 627
3 1000 628
3 1000 629
3 1000 630
3 1000 631
3 1000 632
3 1000 633
3 1000 634
3 1000 635
3 1000 636
3 1000 637
3 1000 638
3 1000 639
3 1000 640
3 1000 641
3 1000 642
3 1000 643
3 1000 644
3 1000 645
3 1000 646
3 1000 647
3 1000 648
3 1000 649
3 1000 650
3 1000 651
3 1000 652
3 1000 653
3 1000 654
3 1000 655
3 1000 656
3 1000 657
3 1000 658
3 1000 659
3 1000 660
3 1000 661
3 1000 662
3 1000 663
3 1000 664
3 1000 665
3 1000 666
3 1000 667
3 1000 668
3 1000 669
3 1000 670
3 1000 671
3 1000 672
3 1000 673
3 1000 674
3 1000 675
3 1000 676
3 1000 677
3 1000 678
3 1000 679
3 1000 680
3 1000 681
3 1000 682
3 1000 683
3 1000 684
3 1000 685
3 1000 686
3 1000 687
3 1000 688
3 1000 689
3 1000 690
3 1000 691
3 1000 692
3 1000 693
3 1000 694
3 1000 695
3 1000 696
3 1000 697
3 1000 698
3 1000 699
3 1000 700
3 1000 701
3 1000 702
3 1000 703
3 1000 704
3 1000 705
3 1000 706
3 1000 707
3 1000 708
3 1000 709
3 1000 710
3 1000 711
3 1000 712
3 1000 713
3 1000 714
3 1000 715
3 1000 716
3 1000 717
3 1000 718
3 1000 719
3 1000 720
3 1000 721
3 1000 722
3 1000 723
3 1000 724
3 1000 725
3 1000 726
3 1000 727
3 1000 728
3 1000 729
3 1000 730
3 1000 731
3 1000 732
3 1000 733
3 1000 734
3 1000 735
3 1000 736
3 1000 737
3 1000 738
3 1000 739
3 1000 740
3 1000 741
3 1000 742
3 1000 743
3 1000 744
3 1000 745
3 1000 746
3 1000 747
3 1000 748
3 1000 749
3 1000 750
3 1000 751
3 1000 752
3 1000 753
3 1000 754
3 1000 755
3 1000 756
3 1000 757
3 1000 758
3 1000 759
3 1000 760
3 1000 761
3 1000 762
3 1000 763
3 1000 764
3 1000 765
3 1000 766
3 1000 767
3 1000 768
3 1000 769
3 1000 770
3 1000 771
3 1000 772
3 1000 773
3 1000 774
3 1000 775
3 1000 776
3 1000 777
3 1000 778
3 1000 779
3 1000 780
3 1000 781
3 1000 782
3 1000 783
3 1000 784
3 1000 785
3 1000 786
3 1000 787
3 1000 788
3 1000 789
3 1000 790
3 1000 791
3 1000 792
3 1000 793
3 1000 794
3 1000 795
3 1000 796
3 1000 797
3 1000 798
3 1000 799
3 1000 800
3 1000 801
3 1000 802
3 1000 803
3 1000 804
3 1000 805
3 1000 806
3 1000 807
3 1000 808
3 1000 809
3 1000 810
3 1000 811
3 1000 812
3 1000 813
3 1000 814
3 1000 815
3 1000 816
3 1000 817
3 1000 818
3 1000 819
3 1000 820
3 1000 821
3 1000 822
3 1000 823
3 1000 824
3 1000 825
3 1000 826
3 1000 827
3 1000 828
3 1000 829
3 1000 830
3 1000 831
3 1000 832
3 1000 833
3 1000 834
3 1000 835
3 1000 836
3 1000 837
3 1000 838
3 1000 839
3 1000 840
3 1000 841
3 1000 842
3 1000 843
3 1000 844
3 1000 845
3 1000 846
3 1000 847
3 1000 848
3 1000 849
3 1000 850
3 1000 851
3 1000 852
3 1000 853
3 1000 854
3 1000 855
3 1000 856
3 1000 857
3 1000 858
3 1000 859
3 1000 860
3 1000 861
3 1000 862
3 1000 863
3 1000 864
3 1000 865
3 1000 866
3 1000 867
3 1000 868
3 1000 869
3 1000 870
3 1000 871
3 1000 872
3 1000 873
3 1000 874
3 1000 875
3 1000 876
3 1000 877
3 1000 878
3 1000 879
3 1000 880
3 1000 881
3 1000 882
3 1000 883
3 1000 884
3 1000 885
3 1000 886
3 1000 887
3 1000 888
3 1000 889
3 1000 890
3 1000 891
3 1000 892
3 1000 893
3 1000 894
3 1000 895
3 1000 896
3 1000 897
3 1000 898
3 1000 899
3 1000 900
3 1000 901
3 1000 902
3 1000 903
3 1000 904
3 1000 905
3 1000 906
3 1000 907
3 1000 908
3 1000 909
3 1000 910
3 1000 911
3 1000 912
3 1000 913
3 1000 914
3 1000 915
3 1000 916
3 1000 917
3 1000 918
3 1000 919
3 1000 920
3 1000 921
3 1000 922
3 1000 923
3 1000 924
3 1000 925
3 1000 926
3 1000 927
3 1000 928
3 1000 929
3 1000 930
3 1000 931
3 1000 932
3 1000 933
3 1000 934
3 1000 935
3 1000 936
3 1000 937
3 1000 938
3 1000 939
3 1000 940
3 1000 941
3 1000 942
3 1000 943
3 1000 944
3 1000 945
3 1000 946
3 1000 947
3 1000 948
3 1000 949
3 1000 950
3 1000 951
3 1000 952
3 1000 953
3 1000 954
3 1000 955
3 1000 956
3 1000 957
3 1000 958
3 1000 959
3 1000 960
3 1000 961
3 1000 962
3 1000 963
3 1000 964
3 1000 965
3 1000 966
3 1000 967
3 1000 968
3 1000 969
3 1000 970
3 1000 971
3 1000 972
3 1000 973
3 1000 974
3 1000 975
3 1000 976
3 1000 977
3 1000 978
3 1000 979
3 1000 980
3 1000 981
3 1000 982
3 1000 983
3 1000 984
3 1000 985
3 1000 986
3 1000 987
3 1000 988
3 1000 989
3 1000 990
3 1000 991
3 1000 992
3 1000 993
3 1000 994
3 1000 995
3 1000 996
3 1000 997
3 1000 998
3 1000 999
3 1000 1000