Insert all 1000 elements using a single FORALL statement : FORALL « PL SQL « Oracle PL / SQL






Insert all 1000 elements using a single FORALL statement

  
SQL>
SQL>
SQL> CREATE TABLE MyTable (
  2    num_col    NUMBER,
  3    char_col   VARCHAR2(60)
  4    );

Table created.

SQL>
SQL>
SQL> set serveroutput on format wrapped
SQL>
SQL> DECLARE
  2    TYPE t_Numbers IS TABLE OF MyTable.num_col%TYPE;
  3    TYPE t_Strings IS TABLE OF MyTable.char_col%TYPE;
  4    v_Numbers t_Numbers := t_Numbers(1);
  5    v_Strings t_Strings := t_Strings(1);
  6
  7  BEGIN
  8    v_Numbers.EXTEND(1000);
  9    v_Strings.EXTEND(1000);
 10    FOR v_Count IN 1..1000 LOOP
 11      v_Numbers(v_Count) := v_Count;
 12      v_Strings(v_Count) := 'Element #' || v_Count;
 13    END LOOP;
 14
 15
 16    FORALL v_Count IN 1..1000
 17      INSERT INTO MyTable VALUES
 18        (v_Numbers(v_Count), v_Strings(v_Count));
 19
 20
 21  END;
 22  /

PL/SQL procedure successfully completed.

SQL>
SQL> select * from MyTable;

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
         1 Element #1
         2 Element #2
         3 Element #3
         4 Element #4
         5 Element #5
         6 Element #6
         7 Element #7
         8 Element #8
         9 Element #9
        10 Element #10
        11 Element #11

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
        12 Element #12
        13 Element #13
        14 Element #14
        15 Element #15
        16 Element #16
        17 Element #17
        18 Element #18
        19 Element #19
        20 Element #20
        21 Element #21
        22 Element #22

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
        23 Element #23
        24 Element #24
        25 Element #25
        26 Element #26
        27 Element #27
        28 Element #28
        29 Element #29
        30 Element #30
        31 Element #31
        32 Element #32
        33 Element #33

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
        34 Element #34
        35 Element #35
        36 Element #36
        37 Element #37
        38 Element #38
        39 Element #39
        40 Element #40
        41 Element #41
        42 Element #42
        43 Element #43
        44 Element #44

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
        45 Element #45
        46 Element #46
        47 Element #47
        48 Element #48
        49 Element #49
        50 Element #50
        51 Element #51
        52 Element #52
        53 Element #53
        54 Element #54
        55 Element #55

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
        56 Element #56
        57 Element #57
        58 Element #58
        59 Element #59
        60 Element #60
        61 Element #61
        62 Element #62
        63 Element #63
        64 Element #64
        65 Element #65
        66 Element #66

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
        67 Element #67
        68 Element #68
        69 Element #69
        70 Element #70
        71 Element #71
        72 Element #72
        73 Element #73
        74 Element #74
        75 Element #75
        76 Element #76
        77 Element #77

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
        78 Element #78
        79 Element #79
        80 Element #80
        81 Element #81
        82 Element #82
        83 Element #83
        84 Element #84
        85 Element #85
        86 Element #86
        87 Element #87
        88 Element #88

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
        89 Element #89
        90 Element #90
        91 Element #91
        92 Element #92
        93 Element #93
        94 Element #94
        95 Element #95
        96 Element #96
        97 Element #97
        98 Element #98
        99 Element #99

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       100 Element #100
       101 Element #101
       102 Element #102
       103 Element #103
       104 Element #104
       105 Element #105
       106 Element #106
       107 Element #107
       108 Element #108
       109 Element #109
       110 Element #110

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       111 Element #111
       112 Element #112
       113 Element #113
       114 Element #114
       115 Element #115
       116 Element #116
       117 Element #117
       118 Element #118
       119 Element #119
       120 Element #120
       121 Element #121

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       122 Element #122
       123 Element #123
       124 Element #124
       125 Element #125
       126 Element #126
       127 Element #127
       128 Element #128
       129 Element #129
       130 Element #130
       131 Element #131
       132 Element #132

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       133 Element #133
       134 Element #134
       135 Element #135
       136 Element #136
       137 Element #137
       138 Element #138
       139 Element #139
       140 Element #140
       141 Element #141
       142 Element #142
       143 Element #143

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       144 Element #144
       145 Element #145
       146 Element #146
       147 Element #147
       148 Element #148
       149 Element #149
       150 Element #150
       151 Element #151
       152 Element #152
       153 Element #153
       154 Element #154

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       155 Element #155
       156 Element #156
       157 Element #157
       158 Element #158
       159 Element #159
       160 Element #160
       161 Element #161
       162 Element #162
       163 Element #163
       164 Element #164
       165 Element #165

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       166 Element #166
       167 Element #167
       168 Element #168
       169 Element #169
       170 Element #170
       171 Element #171
       172 Element #172
       173 Element #173
       174 Element #174
       175 Element #175
       176 Element #176

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       177 Element #177
       178 Element #178
       179 Element #179
       180 Element #180
       181 Element #181
       182 Element #182
       183 Element #183
       184 Element #184
       185 Element #185
       186 Element #186
       187 Element #187

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       188 Element #188
       189 Element #189
       190 Element #190
       191 Element #191
       192 Element #192
       193 Element #193
       194 Element #194
       195 Element #195
       196 Element #196
       197 Element #197
       198 Element #198

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       199 Element #199
       200 Element #200
       201 Element #201
       202 Element #202
       203 Element #203
       204 Element #204
       205 Element #205
       206 Element #206
       207 Element #207
       208 Element #208
       209 Element #209

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       210 Element #210
       211 Element #211
       212 Element #212
       213 Element #213
       214 Element #214
       215 Element #215
       216 Element #216
       217 Element #217
       218 Element #218
       219 Element #219
       220 Element #220

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       221 Element #221
       222 Element #222
       223 Element #223
       224 Element #224
       225 Element #225
       226 Element #226
       227 Element #227
       228 Element #228
       229 Element #229
       230 Element #230
       231 Element #231

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       232 Element #232
       233 Element #233
       234 Element #234
       235 Element #235
       236 Element #236
       237 Element #237
       238 Element #238
       239 Element #239
       240 Element #240
       241 Element #241
       242 Element #242

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       243 Element #243
       244 Element #244
       245 Element #245
       246 Element #246
       247 Element #247
       248 Element #248
       249 Element #249
       250 Element #250
       251 Element #251
       252 Element #252
       253 Element #253

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       254 Element #254
       255 Element #255
       256 Element #256
       257 Element #257
       258 Element #258
       259 Element #259
       260 Element #260
       261 Element #261
       262 Element #262
       263 Element #263
       264 Element #264

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       265 Element #265
       266 Element #266
       267 Element #267
       268 Element #268
       269 Element #269
       270 Element #270
       271 Element #271
       272 Element #272
       273 Element #273
       274 Element #274
       275 Element #275

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       276 Element #276
       277 Element #277
       278 Element #278
       279 Element #279
       280 Element #280
       281 Element #281
       282 Element #282
       283 Element #283
       284 Element #284
       285 Element #285
       286 Element #286

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       287 Element #287
       288 Element #288
       289 Element #289
       290 Element #290
       291 Element #291
       292 Element #292
       293 Element #293
       294 Element #294
       295 Element #295
       296 Element #296
       297 Element #297

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       298 Element #298
       299 Element #299
       300 Element #300
       301 Element #301
       302 Element #302
       303 Element #303
       304 Element #304
       305 Element #305
       306 Element #306
       307 Element #307
       308 Element #308

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       309 Element #309
       310 Element #310
       311 Element #311
       312 Element #312
       313 Element #313
       314 Element #314
       315 Element #315
       316 Element #316
       317 Element #317
       318 Element #318
       319 Element #319

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       320 Element #320
       321 Element #321
       322 Element #322
       323 Element #323
       324 Element #324
       325 Element #325
       326 Element #326
       327 Element #327
       328 Element #328
       329 Element #329
       330 Element #330

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       331 Element #331
       332 Element #332
       333 Element #333
       334 Element #334
       335 Element #335
       336 Element #336
       337 Element #337
       338 Element #338
       339 Element #339
       340 Element #340
       341 Element #341

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       342 Element #342
       343 Element #343
       344 Element #344
       345 Element #345
       346 Element #346
       347 Element #347
       348 Element #348
       349 Element #349
       350 Element #350
       351 Element #351
       352 Element #352

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       353 Element #353
       354 Element #354
       355 Element #355
       356 Element #356
       357 Element #357
       358 Element #358
       359 Element #359
       360 Element #360
       361 Element #361
       362 Element #362
       363 Element #363

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       364 Element #364
       365 Element #365
       366 Element #366
       367 Element #367
       368 Element #368
       369 Element #369
       370 Element #370
       371 Element #371
       372 Element #372
       373 Element #373
       374 Element #374

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       375 Element #375
       376 Element #376
       377 Element #377
       378 Element #378
       379 Element #379
       380 Element #380
       381 Element #381
       382 Element #382
       383 Element #383
       384 Element #384
       385 Element #385

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       386 Element #386
       387 Element #387
       388 Element #388
       389 Element #389
       390 Element #390
       391 Element #391
       392 Element #392
       393 Element #393
       394 Element #394
       395 Element #395
       396 Element #396

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       397 Element #397
       398 Element #398
       399 Element #399
       400 Element #400
       401 Element #401
       402 Element #402
       403 Element #403
       404 Element #404
       405 Element #405
       406 Element #406
       407 Element #407

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       408 Element #408
       409 Element #409
       410 Element #410
       411 Element #411
       412 Element #412
       413 Element #413
       414 Element #414
       415 Element #415
       416 Element #416
       417 Element #417
       418 Element #418

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       419 Element #419
       420 Element #420
       421 Element #421
       422 Element #422
       423 Element #423
       424 Element #424
       425 Element #425
       426 Element #426
       427 Element #427
       428 Element #428
       429 Element #429

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       430 Element #430
       431 Element #431
       432 Element #432
       433 Element #433
       434 Element #434
       435 Element #435
       436 Element #436
       437 Element #437
       438 Element #438
       439 Element #439
       440 Element #440

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       441 Element #441
       442 Element #442
       443 Element #443
       444 Element #444
       445 Element #445
       446 Element #446
       447 Element #447
       448 Element #448
       449 Element #449
       450 Element #450
       451 Element #451

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       452 Element #452
       453 Element #453
       454 Element #454
       455 Element #455
       456 Element #456
       457 Element #457
       458 Element #458
       459 Element #459
       460 Element #460
       461 Element #461
       462 Element #462

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       463 Element #463
       464 Element #464
       465 Element #465
       466 Element #466
       467 Element #467
       468 Element #468
       469 Element #469
       470 Element #470
       471 Element #471
       472 Element #472
       473 Element #473

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       474 Element #474
       475 Element #475
       476 Element #476
       477 Element #477
       478 Element #478
       479 Element #479
       480 Element #480
       481 Element #481
       482 Element #482
       483 Element #483
       484 Element #484

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       485 Element #485
       486 Element #486
       487 Element #487
       488 Element #488
       489 Element #489
       490 Element #490
       491 Element #491
       492 Element #492
       493 Element #493
       494 Element #494
       495 Element #495

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       496 Element #496
       497 Element #497
       498 Element #498
       499 Element #499
       500 Element #500
       501 Element #501
       502 Element #502
       503 Element #503
       504 Element #504
       505 Element #505
       506 Element #506

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       507 Element #507
       508 Element #508
       509 Element #509
       510 Element #510
       511 Element #511
       512 Element #512
       513 Element #513
       514 Element #514
       515 Element #515
       516 Element #516
       517 Element #517

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       518 Element #518
       519 Element #519
       520 Element #520
       521 Element #521
       522 Element #522
       523 Element #523
       524 Element #524
       525 Element #525
       526 Element #526
       527 Element #527
       528 Element #528

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       529 Element #529
       530 Element #530
       531 Element #531
       532 Element #532
       533 Element #533
       534 Element #534
       535 Element #535
       536 Element #536
       537 Element #537
       538 Element #538
       539 Element #539

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       540 Element #540
       541 Element #541
       542 Element #542
       543 Element #543
       544 Element #544
       545 Element #545
       546 Element #546
       547 Element #547
       548 Element #548
       549 Element #549
       550 Element #550

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       551 Element #551
       552 Element #552
       553 Element #553
       554 Element #554
       555 Element #555
       556 Element #556
       557 Element #557
       558 Element #558
       559 Element #559
       560 Element #560
       561 Element #561

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       562 Element #562
       563 Element #563
       564 Element #564
       565 Element #565
       566 Element #566
       567 Element #567
       568 Element #568
       569 Element #569
       570 Element #570
       571 Element #571
       572 Element #572

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       573 Element #573
       574 Element #574
       575 Element #575
       576 Element #576
       577 Element #577
       578 Element #578
       579 Element #579
       580 Element #580
       581 Element #581
       582 Element #582
       583 Element #583

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       584 Element #584
       585 Element #585
       586 Element #586
       587 Element #587
       588 Element #588
       589 Element #589
       590 Element #590
       591 Element #591
       592 Element #592
       593 Element #593
       594 Element #594

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       595 Element #595
       596 Element #596
       597 Element #597
       598 Element #598
       599 Element #599
       600 Element #600
       601 Element #601
       602 Element #602
       603 Element #603
       604 Element #604
       605 Element #605

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       606 Element #606
       607 Element #607
       608 Element #608
       609 Element #609
       610 Element #610
       611 Element #611
       612 Element #612
       613 Element #613
       614 Element #614
       615 Element #615
       616 Element #616

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       617 Element #617
       618 Element #618
       619 Element #619
       620 Element #620
       621 Element #621
       622 Element #622
       623 Element #623
       624 Element #624
       625 Element #625
       626 Element #626
       627 Element #627

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       628 Element #628
       629 Element #629
       630 Element #630
       631 Element #631
       632 Element #632
       633 Element #633
       634 Element #634
       635 Element #635
       636 Element #636
       637 Element #637
       638 Element #638

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       639 Element #639
       640 Element #640
       641 Element #641
       642 Element #642
       643 Element #643
       644 Element #644
       645 Element #645
       646 Element #646
       647 Element #647
       648 Element #648
       649 Element #649

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       650 Element #650
       651 Element #651
       652 Element #652
       653 Element #653
       654 Element #654
       655 Element #655
       656 Element #656
       657 Element #657
       658 Element #658
       659 Element #659
       660 Element #660

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       661 Element #661
       662 Element #662
       663 Element #663
       664 Element #664
       665 Element #665
       666 Element #666
       667 Element #667
       668 Element #668
       669 Element #669
       670 Element #670
       671 Element #671

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       672 Element #672
       673 Element #673
       674 Element #674
       675 Element #675
       676 Element #676
       677 Element #677
       678 Element #678
       679 Element #679
       680 Element #680
       681 Element #681
       682 Element #682

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       683 Element #683
       684 Element #684
       685 Element #685
       686 Element #686
       687 Element #687
       688 Element #688
       689 Element #689
       690 Element #690
       691 Element #691
       692 Element #692
       693 Element #693

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       694 Element #694
       695 Element #695
       696 Element #696
       697 Element #697
       698 Element #698
       699 Element #699
       700 Element #700
       701 Element #701
       702 Element #702
       703 Element #703
       704 Element #704

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       705 Element #705
       706 Element #706
       707 Element #707
       708 Element #708
       709 Element #709
       710 Element #710
       711 Element #711
       712 Element #712
       713 Element #713
       714 Element #714
       715 Element #715

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       716 Element #716
       717 Element #717
       718 Element #718
       719 Element #719
       720 Element #720
       721 Element #721
       722 Element #722
       723 Element #723
       724 Element #724
       725 Element #725
       726 Element #726

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       727 Element #727
       728 Element #728
       729 Element #729
       730 Element #730
       731 Element #731
       732 Element #732
       733 Element #733
       734 Element #734
       735 Element #735
       736 Element #736
       737 Element #737

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       738 Element #738
       739 Element #739
       740 Element #740
       741 Element #741
       742 Element #742
       743 Element #743
       744 Element #744
       745 Element #745
       746 Element #746
       747 Element #747
       748 Element #748

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       749 Element #749
       750 Element #750
       751 Element #751
       752 Element #752
       753 Element #753
       754 Element #754
       755 Element #755
       756 Element #756
       757 Element #757
       758 Element #758
       759 Element #759

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       760 Element #760
       761 Element #761
       762 Element #762
       763 Element #763
       764 Element #764
       765 Element #765
       766 Element #766
       767 Element #767
       768 Element #768
       769 Element #769
       770 Element #770

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       771 Element #771
       772 Element #772
       773 Element #773
       774 Element #774
       775 Element #775
       776 Element #776
       777 Element #777
       778 Element #778
       779 Element #779
       780 Element #780
       781 Element #781

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       782 Element #782
       783 Element #783
       784 Element #784
       785 Element #785
       786 Element #786
       787 Element #787
       788 Element #788
       789 Element #789
       790 Element #790
       791 Element #791
       792 Element #792

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       793 Element #793
       794 Element #794
       795 Element #795
       796 Element #796
       797 Element #797
       798 Element #798
       799 Element #799
       800 Element #800
       801 Element #801
       802 Element #802
       803 Element #803

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       804 Element #804
       805 Element #805
       806 Element #806
       807 Element #807
       808 Element #808
       809 Element #809
       810 Element #810
       811 Element #811
       812 Element #812
       813 Element #813
       814 Element #814

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       815 Element #815
       816 Element #816
       817 Element #817
       818 Element #818
       819 Element #819
       820 Element #820
       821 Element #821
       822 Element #822
       823 Element #823
       824 Element #824
       825 Element #825

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       826 Element #826
       827 Element #827
       828 Element #828
       829 Element #829
       830 Element #830
       831 Element #831
       832 Element #832
       833 Element #833
       834 Element #834
       835 Element #835
       836 Element #836

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       837 Element #837
       838 Element #838
       839 Element #839
       840 Element #840
       841 Element #841
       842 Element #842
       843 Element #843
       844 Element #844
       845 Element #845
       846 Element #846
       847 Element #847

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       848 Element #848
       849 Element #849
       850 Element #850
       851 Element #851
       852 Element #852
       853 Element #853
       854 Element #854
       855 Element #855
       856 Element #856
       857 Element #857
       858 Element #858

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       859 Element #859
       860 Element #860
       861 Element #861
       862 Element #862
       863 Element #863
       864 Element #864
       865 Element #865
       866 Element #866
       867 Element #867
       868 Element #868
       869 Element #869

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       870 Element #870
       871 Element #871
       872 Element #872
       873 Element #873
       874 Element #874
       875 Element #875
       876 Element #876
       877 Element #877
       878 Element #878
       879 Element #879
       880 Element #880

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       881 Element #881
       882 Element #882
       883 Element #883
       884 Element #884
       885 Element #885
       886 Element #886
       887 Element #887
       888 Element #888
       889 Element #889
       890 Element #890
       891 Element #891

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       892 Element #892
       893 Element #893
       894 Element #894
       895 Element #895
       896 Element #896
       897 Element #897
       898 Element #898
       899 Element #899
       900 Element #900
       901 Element #901
       902 Element #902

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       903 Element #903
       904 Element #904
       905 Element #905
       906 Element #906
       907 Element #907
       908 Element #908
       909 Element #909
       910 Element #910
       911 Element #911
       912 Element #912
       913 Element #913

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       914 Element #914
       915 Element #915
       916 Element #916
       917 Element #917
       918 Element #918
       919 Element #919
       920 Element #920
       921 Element #921
       922 Element #922
       923 Element #923
       924 Element #924

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       925 Element #925
       926 Element #926
       927 Element #927
       928 Element #928
       929 Element #929
       930 Element #930
       931 Element #931
       932 Element #932
       933 Element #933
       934 Element #934
       935 Element #935

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       936 Element #936
       937 Element #937
       938 Element #938
       939 Element #939
       940 Element #940
       941 Element #941
       942 Element #942
       943 Element #943
       944 Element #944
       945 Element #945
       946 Element #946

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       947 Element #947
       948 Element #948
       949 Element #949
       950 Element #950
       951 Element #951
       952 Element #952
       953 Element #953
       954 Element #954
       955 Element #955
       956 Element #956
       957 Element #957

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       958 Element #958
       959 Element #959
       960 Element #960
       961 Element #961
       962 Element #962
       963 Element #963
       964 Element #964
       965 Element #965
       966 Element #966
       967 Element #967
       968 Element #968

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       969 Element #969
       970 Element #970
       971 Element #971
       972 Element #972
       973 Element #973
       974 Element #974
       975 Element #975
       976 Element #976
       977 Element #977
       978 Element #978
       979 Element #979

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       980 Element #980
       981 Element #981
       982 Element #982
       983 Element #983
       984 Element #984
       985 Element #985
       986 Element #986
       987 Element #987
       988 Element #988
       989 Element #989
       990 Element #990

   NUM_COL CHAR_COL
---------- ------------------------------------------------------------
       991 Element #991
       992 Element #992
       993 Element #993
       994 Element #994
       995 Element #995
       996 Element #996
       997 Element #997
       998 Element #998
       999 Element #999
      1000 Element #1000

1000 rows selected.

SQL>
SQL> drop table MyTable;

Table dropped.

SQL>
SQL>
SQL>
--

   
  








Related examples in the same category

1.forall from 1 to 50
2.An exception will stop the bulk insert.
3.The SAVE EXCEPTIONS clause will record any exception during the bulk operation, and continue processing.
4.Use a FORALL to move an associative array into a table