If you have a query that contains views, or a query where the columns are not all qualified, the DBMS_UTILITY.EXPAND_SQL_TEXT function might be useful. The DBMS_UTILITY.EXPAND_SQL_TEXT function shows you what your query looks like without the views, and with all the columns qualified.

Note that views do not offer any performance advantage over manually writing out the query using the underlying tables. In fact, if a view contains unnecessary tables, a view can actually be a performance disadvantage.

Looking at your query’s expanded text will help you to understand if you have a well-written query or not. This is important because having a well-written query is critical to getting the best execution plan possible.

If you want to use DBMS_UTILITY.EXPAND_SQL_TEXT, use the snippet of code below and plug your query in place of the “select dummy from dual” statement:

set serveroutput on;

declare
  v_input clob;
  v_output clob;
begin
  $if dbms_db_version.ver_le_9
      or dbms_db_version.ver_le_10 
      or dbms_db_version.ver_le_11 
  $then
    dbms_output.put_line('DBMS_UTILITY.EXPAND_SQL_TEXT requires Oracle 12c or above!');
  $else
    v_input := q'{ 
      --Plug your query in here
       select dummy from dual 
    }';
  
    dbms_utility.expand_sql_text(
        input_sql_text => v_input
      , output_sql_text => v_output
    );
  
    dbms_output.put_line(v_output);
  
  $end
end;
/

PLS-00172: string literal too long

If you encounter error PLS-00172, you might need to break your input string into “bite-sized” chunks. Varchar2’s have a maximum capacity of 32,767 bytes, and if you specify a literal longer than that, then you’ll need to break the chunks up using the TO_CLOB() function.

For example, instead of this:

set serveroutput on;

declare
  v_input clob;
  v_output clob;
begin
  $if dbms_db_version.ver_le_9
      or dbms_db_version.ver_le_10 
      or dbms_db_version.ver_le_11 
  $then
    dbms_output.put_line('DBMS_UTILITY.EXPAND_SQL_TEXT requires Oracle 12c or above!');
  $else
    v_input := q'{ 
      --Plug your query in here
select dummy DUMMY_COLUMN_NUMBER_0
     , dummy DUMMY_COLUMN_NUMBER_1
     , dummy DUMMY_COLUMN_NUMBER_2
     , dummy DUMMY_COLUMN_NUMBER_3
     , dummy DUMMY_COLUMN_NUMBER_4
     , dummy DUMMY_COLUMN_NUMBER_5
     , dummy DUMMY_COLUMN_NUMBER_6
     , dummy DUMMY_COLUMN_NUMBER_7
     , dummy DUMMY_COLUMN_NUMBER_8
     , dummy DUMMY_COLUMN_NUMBER_9
     , dummy DUMMY_COLUMN_NUMBER_10
     , dummy DUMMY_COLUMN_NUMBER_11
     , dummy DUMMY_COLUMN_NUMBER_12
     , dummy DUMMY_COLUMN_NUMBER_13
     , dummy DUMMY_COLUMN_NUMBER_14
     , dummy DUMMY_COLUMN_NUMBER_15
     , dummy DUMMY_COLUMN_NUMBER_16
     , dummy DUMMY_COLUMN_NUMBER_17
     , dummy DUMMY_COLUMN_NUMBER_18
     , dummy DUMMY_COLUMN_NUMBER_19
     , dummy DUMMY_COLUMN_NUMBER_20
     , dummy DUMMY_COLUMN_NUMBER_21
     , dummy DUMMY_COLUMN_NUMBER_22
     , dummy DUMMY_COLUMN_NUMBER_23
     , dummy DUMMY_COLUMN_NUMBER_24
     , dummy DUMMY_COLUMN_NUMBER_25
     , dummy DUMMY_COLUMN_NUMBER_26
     , dummy DUMMY_COLUMN_NUMBER_27
     , dummy DUMMY_COLUMN_NUMBER_28
     , dummy DUMMY_COLUMN_NUMBER_29
     , dummy DUMMY_COLUMN_NUMBER_30
     , dummy DUMMY_COLUMN_NUMBER_31
     , dummy DUMMY_COLUMN_NUMBER_32
     , dummy DUMMY_COLUMN_NUMBER_33
     , dummy DUMMY_COLUMN_NUMBER_34
     , dummy DUMMY_COLUMN_NUMBER_35
     , dummy DUMMY_COLUMN_NUMBER_36
     , dummy DUMMY_COLUMN_NUMBER_37
     , dummy DUMMY_COLUMN_NUMBER_38
     , dummy DUMMY_COLUMN_NUMBER_39
     , dummy DUMMY_COLUMN_NUMBER_40
     , dummy DUMMY_COLUMN_NUMBER_41
     , dummy DUMMY_COLUMN_NUMBER_42
     , dummy DUMMY_COLUMN_NUMBER_43
     , dummy DUMMY_COLUMN_NUMBER_44
     , dummy DUMMY_COLUMN_NUMBER_45
     , dummy DUMMY_COLUMN_NUMBER_46
     , dummy DUMMY_COLUMN_NUMBER_47
     , dummy DUMMY_COLUMN_NUMBER_48
     , dummy DUMMY_COLUMN_NUMBER_49
     , dummy DUMMY_COLUMN_NUMBER_50
     , dummy DUMMY_COLUMN_NUMBER_51
     , dummy DUMMY_COLUMN_NUMBER_52
     , dummy DUMMY_COLUMN_NUMBER_53
     , dummy DUMMY_COLUMN_NUMBER_54
     , dummy DUMMY_COLUMN_NUMBER_55
     , dummy DUMMY_COLUMN_NUMBER_56
     , dummy DUMMY_COLUMN_NUMBER_57
     , dummy DUMMY_COLUMN_NUMBER_58
     , dummy DUMMY_COLUMN_NUMBER_59
     , dummy DUMMY_COLUMN_NUMBER_60
     , dummy DUMMY_COLUMN_NUMBER_61
     , dummy DUMMY_COLUMN_NUMBER_62
     , dummy DUMMY_COLUMN_NUMBER_63
     , dummy DUMMY_COLUMN_NUMBER_64
     , dummy DUMMY_COLUMN_NUMBER_65
     , dummy DUMMY_COLUMN_NUMBER_66
     , dummy DUMMY_COLUMN_NUMBER_67
     , dummy DUMMY_COLUMN_NUMBER_68
     , dummy DUMMY_COLUMN_NUMBER_69
     , dummy DUMMY_COLUMN_NUMBER_70
     , dummy DUMMY_COLUMN_NUMBER_71
     , dummy DUMMY_COLUMN_NUMBER_72
     , dummy DUMMY_COLUMN_NUMBER_73
     , dummy DUMMY_COLUMN_NUMBER_74
     , dummy DUMMY_COLUMN_NUMBER_75
     , dummy DUMMY_COLUMN_NUMBER_76
     , dummy DUMMY_COLUMN_NUMBER_77
     , dummy DUMMY_COLUMN_NUMBER_78
     , dummy DUMMY_COLUMN_NUMBER_79
     , dummy DUMMY_COLUMN_NUMBER_80
     , dummy DUMMY_COLUMN_NUMBER_81
     , dummy DUMMY_COLUMN_NUMBER_82
     , dummy DUMMY_COLUMN_NUMBER_83
     , dummy DUMMY_COLUMN_NUMBER_84
     , dummy DUMMY_COLUMN_NUMBER_85
     , dummy DUMMY_COLUMN_NUMBER_86
     , dummy DUMMY_COLUMN_NUMBER_87
     , dummy DUMMY_COLUMN_NUMBER_88
     , dummy DUMMY_COLUMN_NUMBER_89
     , dummy DUMMY_COLUMN_NUMBER_90
     , dummy DUMMY_COLUMN_NUMBER_91
     , dummy DUMMY_COLUMN_NUMBER_92
     , dummy DUMMY_COLUMN_NUMBER_93
     , dummy DUMMY_COLUMN_NUMBER_94
     , dummy DUMMY_COLUMN_NUMBER_95
     , dummy DUMMY_COLUMN_NUMBER_96
     , dummy DUMMY_COLUMN_NUMBER_97
     , dummy DUMMY_COLUMN_NUMBER_98
     , dummy DUMMY_COLUMN_NUMBER_99
     , dummy DUMMY_COLUMN_NUMBER_100
     , dummy DUMMY_COLUMN_NUMBER_101
     , dummy DUMMY_COLUMN_NUMBER_102
     , dummy DUMMY_COLUMN_NUMBER_103
     , dummy DUMMY_COLUMN_NUMBER_104
     , dummy DUMMY_COLUMN_NUMBER_105
     , dummy DUMMY_COLUMN_NUMBER_106
     , dummy DUMMY_COLUMN_NUMBER_107
     , dummy DUMMY_COLUMN_NUMBER_108
     , dummy DUMMY_COLUMN_NUMBER_109
     , dummy DUMMY_COLUMN_NUMBER_110
     , dummy DUMMY_COLUMN_NUMBER_111
     , dummy DUMMY_COLUMN_NUMBER_112
     , dummy DUMMY_COLUMN_NUMBER_113
     , dummy DUMMY_COLUMN_NUMBER_114
     , dummy DUMMY_COLUMN_NUMBER_115
     , dummy DUMMY_COLUMN_NUMBER_116
     , dummy DUMMY_COLUMN_NUMBER_117
     , dummy DUMMY_COLUMN_NUMBER_118
     , dummy DUMMY_COLUMN_NUMBER_119
     , dummy DUMMY_COLUMN_NUMBER_120
     , dummy DUMMY_COLUMN_NUMBER_121
     , dummy DUMMY_COLUMN_NUMBER_122
     , dummy DUMMY_COLUMN_NUMBER_123
     , dummy DUMMY_COLUMN_NUMBER_124
     , dummy DUMMY_COLUMN_NUMBER_125
     , dummy DUMMY_COLUMN_NUMBER_126
     , dummy DUMMY_COLUMN_NUMBER_127
     , dummy DUMMY_COLUMN_NUMBER_128
     , dummy DUMMY_COLUMN_NUMBER_129
     , dummy DUMMY_COLUMN_NUMBER_130
     , dummy DUMMY_COLUMN_NUMBER_131
     , dummy DUMMY_COLUMN_NUMBER_132
     , dummy DUMMY_COLUMN_NUMBER_133
     , dummy DUMMY_COLUMN_NUMBER_134
     , dummy DUMMY_COLUMN_NUMBER_135
     , dummy DUMMY_COLUMN_NUMBER_136
     , dummy DUMMY_COLUMN_NUMBER_137
     , dummy DUMMY_COLUMN_NUMBER_138
     , dummy DUMMY_COLUMN_NUMBER_139
     , dummy DUMMY_COLUMN_NUMBER_140
     , dummy DUMMY_COLUMN_NUMBER_141
     , dummy DUMMY_COLUMN_NUMBER_142
     , dummy DUMMY_COLUMN_NUMBER_143
     , dummy DUMMY_COLUMN_NUMBER_144
     , dummy DUMMY_COLUMN_NUMBER_145
     , dummy DUMMY_COLUMN_NUMBER_146
     , dummy DUMMY_COLUMN_NUMBER_147
     , dummy DUMMY_COLUMN_NUMBER_148
     , dummy DUMMY_COLUMN_NUMBER_149
     , dummy DUMMY_COLUMN_NUMBER_150
     , dummy DUMMY_COLUMN_NUMBER_151
     , dummy DUMMY_COLUMN_NUMBER_152
     , dummy DUMMY_COLUMN_NUMBER_153
     , dummy DUMMY_COLUMN_NUMBER_154
     , dummy DUMMY_COLUMN_NUMBER_155
     , dummy DUMMY_COLUMN_NUMBER_156
     , dummy DUMMY_COLUMN_NUMBER_157
     , dummy DUMMY_COLUMN_NUMBER_158
     , dummy DUMMY_COLUMN_NUMBER_159
     , dummy DUMMY_COLUMN_NUMBER_160
     , dummy DUMMY_COLUMN_NUMBER_161
     , dummy DUMMY_COLUMN_NUMBER_162
     , dummy DUMMY_COLUMN_NUMBER_163
     , dummy DUMMY_COLUMN_NUMBER_164
     , dummy DUMMY_COLUMN_NUMBER_165
     , dummy DUMMY_COLUMN_NUMBER_166
     , dummy DUMMY_COLUMN_NUMBER_167
     , dummy DUMMY_COLUMN_NUMBER_168
     , dummy DUMMY_COLUMN_NUMBER_169
     , dummy DUMMY_COLUMN_NUMBER_170
     , dummy DUMMY_COLUMN_NUMBER_171
     , dummy DUMMY_COLUMN_NUMBER_172
     , dummy DUMMY_COLUMN_NUMBER_173
     , dummy DUMMY_COLUMN_NUMBER_174
     , dummy DUMMY_COLUMN_NUMBER_175
     , dummy DUMMY_COLUMN_NUMBER_176
     , dummy DUMMY_COLUMN_NUMBER_177
     , dummy DUMMY_COLUMN_NUMBER_178
     , dummy DUMMY_COLUMN_NUMBER_179
     , dummy DUMMY_COLUMN_NUMBER_180
     , dummy DUMMY_COLUMN_NUMBER_181
     , dummy DUMMY_COLUMN_NUMBER_182
     , dummy DUMMY_COLUMN_NUMBER_183
     , dummy DUMMY_COLUMN_NUMBER_184
     , dummy DUMMY_COLUMN_NUMBER_185
     , dummy DUMMY_COLUMN_NUMBER_186
     , dummy DUMMY_COLUMN_NUMBER_187
     , dummy DUMMY_COLUMN_NUMBER_188
     , dummy DUMMY_COLUMN_NUMBER_189
     , dummy DUMMY_COLUMN_NUMBER_190
     , dummy DUMMY_COLUMN_NUMBER_191
     , dummy DUMMY_COLUMN_NUMBER_192
     , dummy DUMMY_COLUMN_NUMBER_193
     , dummy DUMMY_COLUMN_NUMBER_194
     , dummy DUMMY_COLUMN_NUMBER_195
     , dummy DUMMY_COLUMN_NUMBER_196
     , dummy DUMMY_COLUMN_NUMBER_197
     , dummy DUMMY_COLUMN_NUMBER_198
     , dummy DUMMY_COLUMN_NUMBER_199
     , dummy DUMMY_COLUMN_NUMBER_200
     , dummy DUMMY_COLUMN_NUMBER_201
     , dummy DUMMY_COLUMN_NUMBER_202
     , dummy DUMMY_COLUMN_NUMBER_203
     , dummy DUMMY_COLUMN_NUMBER_204
     , dummy DUMMY_COLUMN_NUMBER_205
     , dummy DUMMY_COLUMN_NUMBER_206
     , dummy DUMMY_COLUMN_NUMBER_207
     , dummy DUMMY_COLUMN_NUMBER_208
     , dummy DUMMY_COLUMN_NUMBER_209
     , dummy DUMMY_COLUMN_NUMBER_210
     , dummy DUMMY_COLUMN_NUMBER_211
     , dummy DUMMY_COLUMN_NUMBER_212
     , dummy DUMMY_COLUMN_NUMBER_213
     , dummy DUMMY_COLUMN_NUMBER_214
     , dummy DUMMY_COLUMN_NUMBER_215
     , dummy DUMMY_COLUMN_NUMBER_216
     , dummy DUMMY_COLUMN_NUMBER_217
     , dummy DUMMY_COLUMN_NUMBER_218
     , dummy DUMMY_COLUMN_NUMBER_219
     , dummy DUMMY_COLUMN_NUMBER_220
     , dummy DUMMY_COLUMN_NUMBER_221
     , dummy DUMMY_COLUMN_NUMBER_222
     , dummy DUMMY_COLUMN_NUMBER_223
     , dummy DUMMY_COLUMN_NUMBER_224
     , dummy DUMMY_COLUMN_NUMBER_225
     , dummy DUMMY_COLUMN_NUMBER_226
     , dummy DUMMY_COLUMN_NUMBER_227
     , dummy DUMMY_COLUMN_NUMBER_228
     , dummy DUMMY_COLUMN_NUMBER_229
     , dummy DUMMY_COLUMN_NUMBER_230
     , dummy DUMMY_COLUMN_NUMBER_231
     , dummy DUMMY_COLUMN_NUMBER_232
     , dummy DUMMY_COLUMN_NUMBER_233
     , dummy DUMMY_COLUMN_NUMBER_234
     , dummy DUMMY_COLUMN_NUMBER_235
     , dummy DUMMY_COLUMN_NUMBER_236
     , dummy DUMMY_COLUMN_NUMBER_237
     , dummy DUMMY_COLUMN_NUMBER_238
     , dummy DUMMY_COLUMN_NUMBER_239
     , dummy DUMMY_COLUMN_NUMBER_240
     , dummy DUMMY_COLUMN_NUMBER_241
     , dummy DUMMY_COLUMN_NUMBER_242
     , dummy DUMMY_COLUMN_NUMBER_243
     , dummy DUMMY_COLUMN_NUMBER_244
     , dummy DUMMY_COLUMN_NUMBER_245
     , dummy DUMMY_COLUMN_NUMBER_246
     , dummy DUMMY_COLUMN_NUMBER_247
     , dummy DUMMY_COLUMN_NUMBER_248
     , dummy DUMMY_COLUMN_NUMBER_249
     , dummy DUMMY_COLUMN_NUMBER_250
     , dummy DUMMY_COLUMN_NUMBER_251
     , dummy DUMMY_COLUMN_NUMBER_252
     , dummy DUMMY_COLUMN_NUMBER_253
     , dummy DUMMY_COLUMN_NUMBER_254
     , dummy DUMMY_COLUMN_NUMBER_255
     , dummy DUMMY_COLUMN_NUMBER_256
     , dummy DUMMY_COLUMN_NUMBER_257
     , dummy DUMMY_COLUMN_NUMBER_258
     , dummy DUMMY_COLUMN_NUMBER_259
     , dummy DUMMY_COLUMN_NUMBER_260
     , dummy DUMMY_COLUMN_NUMBER_261
     , dummy DUMMY_COLUMN_NUMBER_262
     , dummy DUMMY_COLUMN_NUMBER_263
     , dummy DUMMY_COLUMN_NUMBER_264
     , dummy DUMMY_COLUMN_NUMBER_265
     , dummy DUMMY_COLUMN_NUMBER_266
     , dummy DUMMY_COLUMN_NUMBER_267
     , dummy DUMMY_COLUMN_NUMBER_268
     , dummy DUMMY_COLUMN_NUMBER_269
     , dummy DUMMY_COLUMN_NUMBER_270
     , dummy DUMMY_COLUMN_NUMBER_271
     , dummy DUMMY_COLUMN_NUMBER_272
     , dummy DUMMY_COLUMN_NUMBER_273
     , dummy DUMMY_COLUMN_NUMBER_274
     , dummy DUMMY_COLUMN_NUMBER_275
     , dummy DUMMY_COLUMN_NUMBER_276
     , dummy DUMMY_COLUMN_NUMBER_277
     , dummy DUMMY_COLUMN_NUMBER_278
     , dummy DUMMY_COLUMN_NUMBER_279
     , dummy DUMMY_COLUMN_NUMBER_280
     , dummy DUMMY_COLUMN_NUMBER_281
     , dummy DUMMY_COLUMN_NUMBER_282
     , dummy DUMMY_COLUMN_NUMBER_283
     , dummy DUMMY_COLUMN_NUMBER_284
     , dummy DUMMY_COLUMN_NUMBER_285
     , dummy DUMMY_COLUMN_NUMBER_286
     , dummy DUMMY_COLUMN_NUMBER_287
     , dummy DUMMY_COLUMN_NUMBER_288
     , dummy DUMMY_COLUMN_NUMBER_289
     , dummy DUMMY_COLUMN_NUMBER_290
     , dummy DUMMY_COLUMN_NUMBER_291
     , dummy DUMMY_COLUMN_NUMBER_292
     , dummy DUMMY_COLUMN_NUMBER_293
     , dummy DUMMY_COLUMN_NUMBER_294
     , dummy DUMMY_COLUMN_NUMBER_295
     , dummy DUMMY_COLUMN_NUMBER_296
     , dummy DUMMY_COLUMN_NUMBER_297
     , dummy DUMMY_COLUMN_NUMBER_298
     , dummy DUMMY_COLUMN_NUMBER_299
     , dummy DUMMY_COLUMN_NUMBER_300
     , dummy DUMMY_COLUMN_NUMBER_301
     , dummy DUMMY_COLUMN_NUMBER_302
     , dummy DUMMY_COLUMN_NUMBER_303
     , dummy DUMMY_COLUMN_NUMBER_304
     , dummy DUMMY_COLUMN_NUMBER_305
     , dummy DUMMY_COLUMN_NUMBER_306
     , dummy DUMMY_COLUMN_NUMBER_307
     , dummy DUMMY_COLUMN_NUMBER_308
     , dummy DUMMY_COLUMN_NUMBER_309
     , dummy DUMMY_COLUMN_NUMBER_310
     , dummy DUMMY_COLUMN_NUMBER_311
     , dummy DUMMY_COLUMN_NUMBER_312
     , dummy DUMMY_COLUMN_NUMBER_313
     , dummy DUMMY_COLUMN_NUMBER_314
     , dummy DUMMY_COLUMN_NUMBER_315
     , dummy DUMMY_COLUMN_NUMBER_316
     , dummy DUMMY_COLUMN_NUMBER_317
     , dummy DUMMY_COLUMN_NUMBER_318
     , dummy DUMMY_COLUMN_NUMBER_319
     , dummy DUMMY_COLUMN_NUMBER_320
     , dummy DUMMY_COLUMN_NUMBER_321
     , dummy DUMMY_COLUMN_NUMBER_322
     , dummy DUMMY_COLUMN_NUMBER_323
     , dummy DUMMY_COLUMN_NUMBER_324
     , dummy DUMMY_COLUMN_NUMBER_325
     , dummy DUMMY_COLUMN_NUMBER_326
     , dummy DUMMY_COLUMN_NUMBER_327
     , dummy DUMMY_COLUMN_NUMBER_328
     , dummy DUMMY_COLUMN_NUMBER_329
     , dummy DUMMY_COLUMN_NUMBER_330
     , dummy DUMMY_COLUMN_NUMBER_331
     , dummy DUMMY_COLUMN_NUMBER_332
     , dummy DUMMY_COLUMN_NUMBER_333
     , dummy DUMMY_COLUMN_NUMBER_334
     , dummy DUMMY_COLUMN_NUMBER_335
     , dummy DUMMY_COLUMN_NUMBER_336
     , dummy DUMMY_COLUMN_NUMBER_337
     , dummy DUMMY_COLUMN_NUMBER_338
     , dummy DUMMY_COLUMN_NUMBER_339
     , dummy DUMMY_COLUMN_NUMBER_340
     , dummy DUMMY_COLUMN_NUMBER_341
     , dummy DUMMY_COLUMN_NUMBER_342
     , dummy DUMMY_COLUMN_NUMBER_343
     , dummy DUMMY_COLUMN_NUMBER_344
     , dummy DUMMY_COLUMN_NUMBER_345
     , dummy DUMMY_COLUMN_NUMBER_346
     , dummy DUMMY_COLUMN_NUMBER_347
     , dummy DUMMY_COLUMN_NUMBER_348
     , dummy DUMMY_COLUMN_NUMBER_349
     , dummy DUMMY_COLUMN_NUMBER_350
     , dummy DUMMY_COLUMN_NUMBER_351
     , dummy DUMMY_COLUMN_NUMBER_352
     , dummy DUMMY_COLUMN_NUMBER_353
     , dummy DUMMY_COLUMN_NUMBER_354
     , dummy DUMMY_COLUMN_NUMBER_355
     , dummy DUMMY_COLUMN_NUMBER_356
     , dummy DUMMY_COLUMN_NUMBER_357
     , dummy DUMMY_COLUMN_NUMBER_358
     , dummy DUMMY_COLUMN_NUMBER_359
     , dummy DUMMY_COLUMN_NUMBER_360
     , dummy DUMMY_COLUMN_NUMBER_361
     , dummy DUMMY_COLUMN_NUMBER_362
     , dummy DUMMY_COLUMN_NUMBER_363
     , dummy DUMMY_COLUMN_NUMBER_364
     , dummy DUMMY_COLUMN_NUMBER_365
     , dummy DUMMY_COLUMN_NUMBER_366
     , dummy DUMMY_COLUMN_NUMBER_367
     , dummy DUMMY_COLUMN_NUMBER_368
     , dummy DUMMY_COLUMN_NUMBER_369
     , dummy DUMMY_COLUMN_NUMBER_370
     , dummy DUMMY_COLUMN_NUMBER_371
     , dummy DUMMY_COLUMN_NUMBER_372
     , dummy DUMMY_COLUMN_NUMBER_373
     , dummy DUMMY_COLUMN_NUMBER_374
     , dummy DUMMY_COLUMN_NUMBER_375
     , dummy DUMMY_COLUMN_NUMBER_376
     , dummy DUMMY_COLUMN_NUMBER_377
     , dummy DUMMY_COLUMN_NUMBER_378
     , dummy DUMMY_COLUMN_NUMBER_379
     , dummy DUMMY_COLUMN_NUMBER_380
     , dummy DUMMY_COLUMN_NUMBER_381
     , dummy DUMMY_COLUMN_NUMBER_382
     , dummy DUMMY_COLUMN_NUMBER_383
     , dummy DUMMY_COLUMN_NUMBER_384
     , dummy DUMMY_COLUMN_NUMBER_385
     , dummy DUMMY_COLUMN_NUMBER_386
     , dummy DUMMY_COLUMN_NUMBER_387
     , dummy DUMMY_COLUMN_NUMBER_388
     , dummy DUMMY_COLUMN_NUMBER_389
     , dummy DUMMY_COLUMN_NUMBER_390
     , dummy DUMMY_COLUMN_NUMBER_391
     , dummy DUMMY_COLUMN_NUMBER_392
     , dummy DUMMY_COLUMN_NUMBER_393
     , dummy DUMMY_COLUMN_NUMBER_394
     , dummy DUMMY_COLUMN_NUMBER_395
     , dummy DUMMY_COLUMN_NUMBER_396
     , dummy DUMMY_COLUMN_NUMBER_397
     , dummy DUMMY_COLUMN_NUMBER_398
     , dummy DUMMY_COLUMN_NUMBER_399
     , dummy DUMMY_COLUMN_NUMBER_400
     , dummy DUMMY_COLUMN_NUMBER_401
     , dummy DUMMY_COLUMN_NUMBER_402
     , dummy DUMMY_COLUMN_NUMBER_403
     , dummy DUMMY_COLUMN_NUMBER_404
     , dummy DUMMY_COLUMN_NUMBER_405
     , dummy DUMMY_COLUMN_NUMBER_406
     , dummy DUMMY_COLUMN_NUMBER_407
     , dummy DUMMY_COLUMN_NUMBER_408
     , dummy DUMMY_COLUMN_NUMBER_409
     , dummy DUMMY_COLUMN_NUMBER_410
     , dummy DUMMY_COLUMN_NUMBER_411
     , dummy DUMMY_COLUMN_NUMBER_412
     , dummy DUMMY_COLUMN_NUMBER_413
     , dummy DUMMY_COLUMN_NUMBER_414
     , dummy DUMMY_COLUMN_NUMBER_415
     , dummy DUMMY_COLUMN_NUMBER_416
     , dummy DUMMY_COLUMN_NUMBER_417
     , dummy DUMMY_COLUMN_NUMBER_418
     , dummy DUMMY_COLUMN_NUMBER_419
     , dummy DUMMY_COLUMN_NUMBER_420
     , dummy DUMMY_COLUMN_NUMBER_421
     , dummy DUMMY_COLUMN_NUMBER_422
     , dummy DUMMY_COLUMN_NUMBER_423
     , dummy DUMMY_COLUMN_NUMBER_424
     , dummy DUMMY_COLUMN_NUMBER_425
     , dummy DUMMY_COLUMN_NUMBER_426
     , dummy DUMMY_COLUMN_NUMBER_427
     , dummy DUMMY_COLUMN_NUMBER_428
     , dummy DUMMY_COLUMN_NUMBER_429
     , dummy DUMMY_COLUMN_NUMBER_430
     , dummy DUMMY_COLUMN_NUMBER_431
     , dummy DUMMY_COLUMN_NUMBER_432
     , dummy DUMMY_COLUMN_NUMBER_433
     , dummy DUMMY_COLUMN_NUMBER_434
     , dummy DUMMY_COLUMN_NUMBER_435
     , dummy DUMMY_COLUMN_NUMBER_436
     , dummy DUMMY_COLUMN_NUMBER_437
     , dummy DUMMY_COLUMN_NUMBER_438
     , dummy DUMMY_COLUMN_NUMBER_439
     , dummy DUMMY_COLUMN_NUMBER_440
     , dummy DUMMY_COLUMN_NUMBER_441
     , dummy DUMMY_COLUMN_NUMBER_442
     , dummy DUMMY_COLUMN_NUMBER_443
     , dummy DUMMY_COLUMN_NUMBER_444
     , dummy DUMMY_COLUMN_NUMBER_445
     , dummy DUMMY_COLUMN_NUMBER_446
     , dummy DUMMY_COLUMN_NUMBER_447
     , dummy DUMMY_COLUMN_NUMBER_448
     , dummy DUMMY_COLUMN_NUMBER_449
     , dummy DUMMY_COLUMN_NUMBER_450
     , dummy DUMMY_COLUMN_NUMBER_451
     , dummy DUMMY_COLUMN_NUMBER_452
     , dummy DUMMY_COLUMN_NUMBER_453
     , dummy DUMMY_COLUMN_NUMBER_454
     , dummy DUMMY_COLUMN_NUMBER_455
     , dummy DUMMY_COLUMN_NUMBER_456
     , dummy DUMMY_COLUMN_NUMBER_457
     , dummy DUMMY_COLUMN_NUMBER_458
     , dummy DUMMY_COLUMN_NUMBER_459
     , dummy DUMMY_COLUMN_NUMBER_460
     , dummy DUMMY_COLUMN_NUMBER_461
     , dummy DUMMY_COLUMN_NUMBER_462
     , dummy DUMMY_COLUMN_NUMBER_463
     , dummy DUMMY_COLUMN_NUMBER_464
     , dummy DUMMY_COLUMN_NUMBER_465
     , dummy DUMMY_COLUMN_NUMBER_466
     , dummy DUMMY_COLUMN_NUMBER_467
     , dummy DUMMY_COLUMN_NUMBER_468
     , dummy DUMMY_COLUMN_NUMBER_469
     , dummy DUMMY_COLUMN_NUMBER_470
     , dummy DUMMY_COLUMN_NUMBER_471
     , dummy DUMMY_COLUMN_NUMBER_472
     , dummy DUMMY_COLUMN_NUMBER_473
     , dummy DUMMY_COLUMN_NUMBER_474
     , dummy DUMMY_COLUMN_NUMBER_475
     , dummy DUMMY_COLUMN_NUMBER_476
     , dummy DUMMY_COLUMN_NUMBER_477
     , dummy DUMMY_COLUMN_NUMBER_478
     , dummy DUMMY_COLUMN_NUMBER_479
     , dummy DUMMY_COLUMN_NUMBER_480
     , dummy DUMMY_COLUMN_NUMBER_481
     , dummy DUMMY_COLUMN_NUMBER_482
     , dummy DUMMY_COLUMN_NUMBER_483
     , dummy DUMMY_COLUMN_NUMBER_484
     , dummy DUMMY_COLUMN_NUMBER_485
     , dummy DUMMY_COLUMN_NUMBER_486
     , dummy DUMMY_COLUMN_NUMBER_487
     , dummy DUMMY_COLUMN_NUMBER_488
     , dummy DUMMY_COLUMN_NUMBER_489
     , dummy DUMMY_COLUMN_NUMBER_490
     , dummy DUMMY_COLUMN_NUMBER_491
     , dummy DUMMY_COLUMN_NUMBER_492
     , dummy DUMMY_COLUMN_NUMBER_493
     , dummy DUMMY_COLUMN_NUMBER_494
     , dummy DUMMY_COLUMN_NUMBER_495
     , dummy DUMMY_COLUMN_NUMBER_496
     , dummy DUMMY_COLUMN_NUMBER_497
     , dummy DUMMY_COLUMN_NUMBER_498
     , dummy DUMMY_COLUMN_NUMBER_499
     , dummy DUMMY_COLUMN_NUMBER_500
     , dummy DUMMY_COLUMN_NUMBER_501
     , dummy DUMMY_COLUMN_NUMBER_502
     , dummy DUMMY_COLUMN_NUMBER_503
     , dummy DUMMY_COLUMN_NUMBER_504
     , dummy DUMMY_COLUMN_NUMBER_505
     , dummy DUMMY_COLUMN_NUMBER_506
     , dummy DUMMY_COLUMN_NUMBER_507
     , dummy DUMMY_COLUMN_NUMBER_508
     , dummy DUMMY_COLUMN_NUMBER_509
     , dummy DUMMY_COLUMN_NUMBER_510
     , dummy DUMMY_COLUMN_NUMBER_511
     , dummy DUMMY_COLUMN_NUMBER_512
     , dummy DUMMY_COLUMN_NUMBER_513
     , dummy DUMMY_COLUMN_NUMBER_514
     , dummy DUMMY_COLUMN_NUMBER_515
     , dummy DUMMY_COLUMN_NUMBER_516
     , dummy DUMMY_COLUMN_NUMBER_517
     , dummy DUMMY_COLUMN_NUMBER_518
     , dummy DUMMY_COLUMN_NUMBER_519
     , dummy DUMMY_COLUMN_NUMBER_520
     , dummy DUMMY_COLUMN_NUMBER_521
     , dummy DUMMY_COLUMN_NUMBER_522
     , dummy DUMMY_COLUMN_NUMBER_523
     , dummy DUMMY_COLUMN_NUMBER_524
     , dummy DUMMY_COLUMN_NUMBER_525
     , dummy DUMMY_COLUMN_NUMBER_526
     , dummy DUMMY_COLUMN_NUMBER_527
     , dummy DUMMY_COLUMN_NUMBER_528
     , dummy DUMMY_COLUMN_NUMBER_529
     , dummy DUMMY_COLUMN_NUMBER_530
     , dummy DUMMY_COLUMN_NUMBER_531
     , dummy DUMMY_COLUMN_NUMBER_532
     , dummy DUMMY_COLUMN_NUMBER_533
     , dummy DUMMY_COLUMN_NUMBER_534
     , dummy DUMMY_COLUMN_NUMBER_535
     , dummy DUMMY_COLUMN_NUMBER_536
     , dummy DUMMY_COLUMN_NUMBER_537
     , dummy DUMMY_COLUMN_NUMBER_538
     , dummy DUMMY_COLUMN_NUMBER_539
     , dummy DUMMY_COLUMN_NUMBER_540
     , dummy DUMMY_COLUMN_NUMBER_541
     , dummy DUMMY_COLUMN_NUMBER_542
     , dummy DUMMY_COLUMN_NUMBER_543
     , dummy DUMMY_COLUMN_NUMBER_544
     , dummy DUMMY_COLUMN_NUMBER_545
     , dummy DUMMY_COLUMN_NUMBER_546
     , dummy DUMMY_COLUMN_NUMBER_547
     , dummy DUMMY_COLUMN_NUMBER_548
     , dummy DUMMY_COLUMN_NUMBER_549
     , dummy DUMMY_COLUMN_NUMBER_550
     , dummy DUMMY_COLUMN_NUMBER_551
     , dummy DUMMY_COLUMN_NUMBER_552
     , dummy DUMMY_COLUMN_NUMBER_553
     , dummy DUMMY_COLUMN_NUMBER_554
     , dummy DUMMY_COLUMN_NUMBER_555
     , dummy DUMMY_COLUMN_NUMBER_556
     , dummy DUMMY_COLUMN_NUMBER_557
     , dummy DUMMY_COLUMN_NUMBER_558
     , dummy DUMMY_COLUMN_NUMBER_559
     , dummy DUMMY_COLUMN_NUMBER_560
     , dummy DUMMY_COLUMN_NUMBER_561
     , dummy DUMMY_COLUMN_NUMBER_562
     , dummy DUMMY_COLUMN_NUMBER_563
     , dummy DUMMY_COLUMN_NUMBER_564
     , dummy DUMMY_COLUMN_NUMBER_565
     , dummy DUMMY_COLUMN_NUMBER_566
     , dummy DUMMY_COLUMN_NUMBER_567
     , dummy DUMMY_COLUMN_NUMBER_568
     , dummy DUMMY_COLUMN_NUMBER_569
     , dummy DUMMY_COLUMN_NUMBER_570
     , dummy DUMMY_COLUMN_NUMBER_571
     , dummy DUMMY_COLUMN_NUMBER_572
     , dummy DUMMY_COLUMN_NUMBER_573
     , dummy DUMMY_COLUMN_NUMBER_574
     , dummy DUMMY_COLUMN_NUMBER_575
     , dummy DUMMY_COLUMN_NUMBER_576
     , dummy DUMMY_COLUMN_NUMBER_577
     , dummy DUMMY_COLUMN_NUMBER_578
     , dummy DUMMY_COLUMN_NUMBER_579
     , dummy DUMMY_COLUMN_NUMBER_580
     , dummy DUMMY_COLUMN_NUMBER_581
     , dummy DUMMY_COLUMN_NUMBER_582
     , dummy DUMMY_COLUMN_NUMBER_583
     , dummy DUMMY_COLUMN_NUMBER_584
     , dummy DUMMY_COLUMN_NUMBER_585
     , dummy DUMMY_COLUMN_NUMBER_586
     , dummy DUMMY_COLUMN_NUMBER_587
     , dummy DUMMY_COLUMN_NUMBER_588
     , dummy DUMMY_COLUMN_NUMBER_589
     , dummy DUMMY_COLUMN_NUMBER_590
     , dummy DUMMY_COLUMN_NUMBER_591
     , dummy DUMMY_COLUMN_NUMBER_592
     , dummy DUMMY_COLUMN_NUMBER_593
     , dummy DUMMY_COLUMN_NUMBER_594
     , dummy DUMMY_COLUMN_NUMBER_595
     , dummy DUMMY_COLUMN_NUMBER_596
     , dummy DUMMY_COLUMN_NUMBER_597
     , dummy DUMMY_COLUMN_NUMBER_598
     , dummy DUMMY_COLUMN_NUMBER_599
     , dummy DUMMY_COLUMN_NUMBER_600
     , dummy DUMMY_COLUMN_NUMBER_601
     , dummy DUMMY_COLUMN_NUMBER_602
     , dummy DUMMY_COLUMN_NUMBER_603
     , dummy DUMMY_COLUMN_NUMBER_604
     , dummy DUMMY_COLUMN_NUMBER_605
     , dummy DUMMY_COLUMN_NUMBER_606
     , dummy DUMMY_COLUMN_NUMBER_607
     , dummy DUMMY_COLUMN_NUMBER_608
     , dummy DUMMY_COLUMN_NUMBER_609
     , dummy DUMMY_COLUMN_NUMBER_610
     , dummy DUMMY_COLUMN_NUMBER_611
     , dummy DUMMY_COLUMN_NUMBER_612
     , dummy DUMMY_COLUMN_NUMBER_613
     , dummy DUMMY_COLUMN_NUMBER_614
     , dummy DUMMY_COLUMN_NUMBER_615
     , dummy DUMMY_COLUMN_NUMBER_616
     , dummy DUMMY_COLUMN_NUMBER_617
     , dummy DUMMY_COLUMN_NUMBER_618
     , dummy DUMMY_COLUMN_NUMBER_619
     , dummy DUMMY_COLUMN_NUMBER_620
     , dummy DUMMY_COLUMN_NUMBER_621
     , dummy DUMMY_COLUMN_NUMBER_622
     , dummy DUMMY_COLUMN_NUMBER_623
     , dummy DUMMY_COLUMN_NUMBER_624
     , dummy DUMMY_COLUMN_NUMBER_625
     , dummy DUMMY_COLUMN_NUMBER_626
     , dummy DUMMY_COLUMN_NUMBER_627
     , dummy DUMMY_COLUMN_NUMBER_628
     , dummy DUMMY_COLUMN_NUMBER_629
     , dummy DUMMY_COLUMN_NUMBER_630
     , dummy DUMMY_COLUMN_NUMBER_631
     , dummy DUMMY_COLUMN_NUMBER_632
     , dummy DUMMY_COLUMN_NUMBER_633
     , dummy DUMMY_COLUMN_NUMBER_634
     , dummy DUMMY_COLUMN_NUMBER_635
     , dummy DUMMY_COLUMN_NUMBER_636
     , dummy DUMMY_COLUMN_NUMBER_637
     , dummy DUMMY_COLUMN_NUMBER_638
     , dummy DUMMY_COLUMN_NUMBER_639
     , dummy DUMMY_COLUMN_NUMBER_640
     , dummy DUMMY_COLUMN_NUMBER_641
     , dummy DUMMY_COLUMN_NUMBER_642
     , dummy DUMMY_COLUMN_NUMBER_643
     , dummy DUMMY_COLUMN_NUMBER_644
     , dummy DUMMY_COLUMN_NUMBER_645
     , dummy DUMMY_COLUMN_NUMBER_646
     , dummy DUMMY_COLUMN_NUMBER_647
     , dummy DUMMY_COLUMN_NUMBER_648
     , dummy DUMMY_COLUMN_NUMBER_649
     , dummy DUMMY_COLUMN_NUMBER_650
     , dummy DUMMY_COLUMN_NUMBER_651
     , dummy DUMMY_COLUMN_NUMBER_652
     , dummy DUMMY_COLUMN_NUMBER_653
     , dummy DUMMY_COLUMN_NUMBER_654
     , dummy DUMMY_COLUMN_NUMBER_655
     , dummy DUMMY_COLUMN_NUMBER_656
     , dummy DUMMY_COLUMN_NUMBER_657
     , dummy DUMMY_COLUMN_NUMBER_658
     , dummy DUMMY_COLUMN_NUMBER_659
     , dummy DUMMY_COLUMN_NUMBER_660
     , dummy DUMMY_COLUMN_NUMBER_661
     , dummy DUMMY_COLUMN_NUMBER_662
     , dummy DUMMY_COLUMN_NUMBER_663
     , dummy DUMMY_COLUMN_NUMBER_664
     , dummy DUMMY_COLUMN_NUMBER_665
     , dummy DUMMY_COLUMN_NUMBER_666
     , dummy DUMMY_COLUMN_NUMBER_667
     , dummy DUMMY_COLUMN_NUMBER_668
     , dummy DUMMY_COLUMN_NUMBER_669
     , dummy DUMMY_COLUMN_NUMBER_670
     , dummy DUMMY_COLUMN_NUMBER_671
     , dummy DUMMY_COLUMN_NUMBER_672
     , dummy DUMMY_COLUMN_NUMBER_673
     , dummy DUMMY_COLUMN_NUMBER_674
     , dummy DUMMY_COLUMN_NUMBER_675
     , dummy DUMMY_COLUMN_NUMBER_676
     , dummy DUMMY_COLUMN_NUMBER_677
     , dummy DUMMY_COLUMN_NUMBER_678
     , dummy DUMMY_COLUMN_NUMBER_679
     , dummy DUMMY_COLUMN_NUMBER_680
     , dummy DUMMY_COLUMN_NUMBER_681
     , dummy DUMMY_COLUMN_NUMBER_682
     , dummy DUMMY_COLUMN_NUMBER_683
     , dummy DUMMY_COLUMN_NUMBER_684
     , dummy DUMMY_COLUMN_NUMBER_685
     , dummy DUMMY_COLUMN_NUMBER_686
     , dummy DUMMY_COLUMN_NUMBER_687
     , dummy DUMMY_COLUMN_NUMBER_688
     , dummy DUMMY_COLUMN_NUMBER_689
     , dummy DUMMY_COLUMN_NUMBER_690
     , dummy DUMMY_COLUMN_NUMBER_691
     , dummy DUMMY_COLUMN_NUMBER_692
     , dummy DUMMY_COLUMN_NUMBER_693
     , dummy DUMMY_COLUMN_NUMBER_694
     , dummy DUMMY_COLUMN_NUMBER_695
     , dummy DUMMY_COLUMN_NUMBER_696
     , dummy DUMMY_COLUMN_NUMBER_697
     , dummy DUMMY_COLUMN_NUMBER_698
     , dummy DUMMY_COLUMN_NUMBER_699
     , dummy DUMMY_COLUMN_NUMBER_700
     , dummy DUMMY_COLUMN_NUMBER_701
     , dummy DUMMY_COLUMN_NUMBER_702
     , dummy DUMMY_COLUMN_NUMBER_703
     , dummy DUMMY_COLUMN_NUMBER_704
     , dummy DUMMY_COLUMN_NUMBER_705
     , dummy DUMMY_COLUMN_NUMBER_706
     , dummy DUMMY_COLUMN_NUMBER_707
     , dummy DUMMY_COLUMN_NUMBER_708
     , dummy DUMMY_COLUMN_NUMBER_709
     , dummy DUMMY_COLUMN_NUMBER_710
     , dummy DUMMY_COLUMN_NUMBER_711
     , dummy DUMMY_COLUMN_NUMBER_712
     , dummy DUMMY_COLUMN_NUMBER_713
     , dummy DUMMY_COLUMN_NUMBER_714
     , dummy DUMMY_COLUMN_NUMBER_715
     , dummy DUMMY_COLUMN_NUMBER_716
     , dummy DUMMY_COLUMN_NUMBER_717
     , dummy DUMMY_COLUMN_NUMBER_718
     , dummy DUMMY_COLUMN_NUMBER_719
     , dummy DUMMY_COLUMN_NUMBER_720
     , dummy DUMMY_COLUMN_NUMBER_721
     , dummy DUMMY_COLUMN_NUMBER_722
     , dummy DUMMY_COLUMN_NUMBER_723
     , dummy DUMMY_COLUMN_NUMBER_724
     , dummy DUMMY_COLUMN_NUMBER_725
     , dummy DUMMY_COLUMN_NUMBER_726
     , dummy DUMMY_COLUMN_NUMBER_727
     , dummy DUMMY_COLUMN_NUMBER_728
     , dummy DUMMY_COLUMN_NUMBER_729
     , dummy DUMMY_COLUMN_NUMBER_730
     , dummy DUMMY_COLUMN_NUMBER_731
     , dummy DUMMY_COLUMN_NUMBER_732
     , dummy DUMMY_COLUMN_NUMBER_733
     , dummy DUMMY_COLUMN_NUMBER_734
     , dummy DUMMY_COLUMN_NUMBER_735
     , dummy DUMMY_COLUMN_NUMBER_736
     , dummy DUMMY_COLUMN_NUMBER_737
     , dummy DUMMY_COLUMN_NUMBER_738
     , dummy DUMMY_COLUMN_NUMBER_739
     , dummy DUMMY_COLUMN_NUMBER_740
     , dummy DUMMY_COLUMN_NUMBER_741
     , dummy DUMMY_COLUMN_NUMBER_742
     , dummy DUMMY_COLUMN_NUMBER_743
     , dummy DUMMY_COLUMN_NUMBER_744
     , dummy DUMMY_COLUMN_NUMBER_745
     , dummy DUMMY_COLUMN_NUMBER_746
     , dummy DUMMY_COLUMN_NUMBER_747
     , dummy DUMMY_COLUMN_NUMBER_748
     , dummy DUMMY_COLUMN_NUMBER_749
     , dummy DUMMY_COLUMN_NUMBER_750
     , dummy DUMMY_COLUMN_NUMBER_751
     , dummy DUMMY_COLUMN_NUMBER_752
     , dummy DUMMY_COLUMN_NUMBER_753
     , dummy DUMMY_COLUMN_NUMBER_754
     , dummy DUMMY_COLUMN_NUMBER_755
     , dummy DUMMY_COLUMN_NUMBER_756
     , dummy DUMMY_COLUMN_NUMBER_757
     , dummy DUMMY_COLUMN_NUMBER_758
     , dummy DUMMY_COLUMN_NUMBER_759
     , dummy DUMMY_COLUMN_NUMBER_760
     , dummy DUMMY_COLUMN_NUMBER_761
     , dummy DUMMY_COLUMN_NUMBER_762
     , dummy DUMMY_COLUMN_NUMBER_763
     , dummy DUMMY_COLUMN_NUMBER_764
     , dummy DUMMY_COLUMN_NUMBER_765
     , dummy DUMMY_COLUMN_NUMBER_766
     , dummy DUMMY_COLUMN_NUMBER_767
     , dummy DUMMY_COLUMN_NUMBER_768
     , dummy DUMMY_COLUMN_NUMBER_769
     , dummy DUMMY_COLUMN_NUMBER_770
     , dummy DUMMY_COLUMN_NUMBER_771
     , dummy DUMMY_COLUMN_NUMBER_772
     , dummy DUMMY_COLUMN_NUMBER_773
     , dummy DUMMY_COLUMN_NUMBER_774
     , dummy DUMMY_COLUMN_NUMBER_775
     , dummy DUMMY_COLUMN_NUMBER_776
     , dummy DUMMY_COLUMN_NUMBER_777
     , dummy DUMMY_COLUMN_NUMBER_778
     , dummy DUMMY_COLUMN_NUMBER_779
     , dummy DUMMY_COLUMN_NUMBER_780
     , dummy DUMMY_COLUMN_NUMBER_781
     , dummy DUMMY_COLUMN_NUMBER_782
     , dummy DUMMY_COLUMN_NUMBER_783
     , dummy DUMMY_COLUMN_NUMBER_784
     , dummy DUMMY_COLUMN_NUMBER_785
     , dummy DUMMY_COLUMN_NUMBER_786
     , dummy DUMMY_COLUMN_NUMBER_787
     , dummy DUMMY_COLUMN_NUMBER_788
     , dummy DUMMY_COLUMN_NUMBER_789
     , dummy DUMMY_COLUMN_NUMBER_790
     , dummy DUMMY_COLUMN_NUMBER_791
     , dummy DUMMY_COLUMN_NUMBER_792
     , dummy DUMMY_COLUMN_NUMBER_793
     , dummy DUMMY_COLUMN_NUMBER_794
     , dummy DUMMY_COLUMN_NUMBER_795
     , dummy DUMMY_COLUMN_NUMBER_796
     , dummy DUMMY_COLUMN_NUMBER_797
     , dummy DUMMY_COLUMN_NUMBER_798
     , dummy DUMMY_COLUMN_NUMBER_799
     , dummy DUMMY_COLUMN_NUMBER_800
     , dummy DUMMY_COLUMN_NUMBER_801
     , dummy DUMMY_COLUMN_NUMBER_802
     , dummy DUMMY_COLUMN_NUMBER_803
     , dummy DUMMY_COLUMN_NUMBER_804
     , dummy DUMMY_COLUMN_NUMBER_805
     , dummy DUMMY_COLUMN_NUMBER_806
     , dummy DUMMY_COLUMN_NUMBER_807
     , dummy DUMMY_COLUMN_NUMBER_808
     , dummy DUMMY_COLUMN_NUMBER_809
     , dummy DUMMY_COLUMN_NUMBER_810
     , dummy DUMMY_COLUMN_NUMBER_811
     , dummy DUMMY_COLUMN_NUMBER_812
     , dummy DUMMY_COLUMN_NUMBER_813
     , dummy DUMMY_COLUMN_NUMBER_814
     , dummy DUMMY_COLUMN_NUMBER_815
     , dummy DUMMY_COLUMN_NUMBER_816
     , dummy DUMMY_COLUMN_NUMBER_817
     , dummy DUMMY_COLUMN_NUMBER_818
     , dummy DUMMY_COLUMN_NUMBER_819
     , dummy DUMMY_COLUMN_NUMBER_820
     , dummy DUMMY_COLUMN_NUMBER_821
     , dummy DUMMY_COLUMN_NUMBER_822
     , dummy DUMMY_COLUMN_NUMBER_823
     , dummy DUMMY_COLUMN_NUMBER_824
     , dummy DUMMY_COLUMN_NUMBER_825
     , dummy DUMMY_COLUMN_NUMBER_826
     , dummy DUMMY_COLUMN_NUMBER_827
     , dummy DUMMY_COLUMN_NUMBER_828
     , dummy DUMMY_COLUMN_NUMBER_829
     , dummy DUMMY_COLUMN_NUMBER_830
     , dummy DUMMY_COLUMN_NUMBER_831
     , dummy DUMMY_COLUMN_NUMBER_832
     , dummy DUMMY_COLUMN_NUMBER_833
     , dummy DUMMY_COLUMN_NUMBER_834
     , dummy DUMMY_COLUMN_NUMBER_835
     , dummy DUMMY_COLUMN_NUMBER_836
     , dummy DUMMY_COLUMN_NUMBER_837
     , dummy DUMMY_COLUMN_NUMBER_838
     , dummy DUMMY_COLUMN_NUMBER_839
     , dummy DUMMY_COLUMN_NUMBER_840
     , dummy DUMMY_COLUMN_NUMBER_841
     , dummy DUMMY_COLUMN_NUMBER_842
     , dummy DUMMY_COLUMN_NUMBER_843
     , dummy DUMMY_COLUMN_NUMBER_844
     , dummy DUMMY_COLUMN_NUMBER_845
     , dummy DUMMY_COLUMN_NUMBER_846
     , dummy DUMMY_COLUMN_NUMBER_847
     , dummy DUMMY_COLUMN_NUMBER_848
     , dummy DUMMY_COLUMN_NUMBER_849
     , dummy DUMMY_COLUMN_NUMBER_850
     , dummy DUMMY_COLUMN_NUMBER_851
     , dummy DUMMY_COLUMN_NUMBER_852
     , dummy DUMMY_COLUMN_NUMBER_853
     , dummy DUMMY_COLUMN_NUMBER_854
     , dummy DUMMY_COLUMN_NUMBER_855
     , dummy DUMMY_COLUMN_NUMBER_856
     , dummy DUMMY_COLUMN_NUMBER_857
     , dummy DUMMY_COLUMN_NUMBER_858
     , dummy DUMMY_COLUMN_NUMBER_859
     , dummy DUMMY_COLUMN_NUMBER_860
     , dummy DUMMY_COLUMN_NUMBER_861
     , dummy DUMMY_COLUMN_NUMBER_862
     , dummy DUMMY_COLUMN_NUMBER_863
     , dummy DUMMY_COLUMN_NUMBER_864
     , dummy DUMMY_COLUMN_NUMBER_865
     , dummy DUMMY_COLUMN_NUMBER_866
     , dummy DUMMY_COLUMN_NUMBER_867
     , dummy DUMMY_COLUMN_NUMBER_868
     , dummy DUMMY_COLUMN_NUMBER_869
     , dummy DUMMY_COLUMN_NUMBER_870
     , dummy DUMMY_COLUMN_NUMBER_871
     , dummy DUMMY_COLUMN_NUMBER_872
     , dummy DUMMY_COLUMN_NUMBER_873
     , dummy DUMMY_COLUMN_NUMBER_874
     , dummy DUMMY_COLUMN_NUMBER_875
     , dummy DUMMY_COLUMN_NUMBER_876
     , dummy DUMMY_COLUMN_NUMBER_877
     , dummy DUMMY_COLUMN_NUMBER_878
     , dummy DUMMY_COLUMN_NUMBER_879
     , dummy DUMMY_COLUMN_NUMBER_880
     , dummy DUMMY_COLUMN_NUMBER_881
     , dummy DUMMY_COLUMN_NUMBER_882
     , dummy DUMMY_COLUMN_NUMBER_883
     , dummy DUMMY_COLUMN_NUMBER_884
     , dummy DUMMY_COLUMN_NUMBER_885
     , dummy DUMMY_COLUMN_NUMBER_886
     , dummy DUMMY_COLUMN_NUMBER_887
     , dummy DUMMY_COLUMN_NUMBER_888
     , dummy DUMMY_COLUMN_NUMBER_889
     , dummy DUMMY_COLUMN_NUMBER_890
     , dummy DUMMY_COLUMN_NUMBER_891
     , dummy DUMMY_COLUMN_NUMBER_892
     , dummy DUMMY_COLUMN_NUMBER_893
     , dummy DUMMY_COLUMN_NUMBER_894
     , dummy DUMMY_COLUMN_NUMBER_895
     , dummy DUMMY_COLUMN_NUMBER_896
     , dummy DUMMY_COLUMN_NUMBER_897
     , dummy DUMMY_COLUMN_NUMBER_898
     , dummy DUMMY_COLUMN_NUMBER_899
     , dummy DUMMY_COLUMN_NUMBER_900
     , dummy DUMMY_COLUMN_NUMBER_901
     , dummy DUMMY_COLUMN_NUMBER_902
     , dummy DUMMY_COLUMN_NUMBER_903
     , dummy DUMMY_COLUMN_NUMBER_904
     , dummy DUMMY_COLUMN_NUMBER_905
     , dummy DUMMY_COLUMN_NUMBER_906
     , dummy DUMMY_COLUMN_NUMBER_907
     , dummy DUMMY_COLUMN_NUMBER_908
     , dummy DUMMY_COLUMN_NUMBER_909
     , dummy DUMMY_COLUMN_NUMBER_910
     , dummy DUMMY_COLUMN_NUMBER_911
     , dummy DUMMY_COLUMN_NUMBER_912
     , dummy DUMMY_COLUMN_NUMBER_913
     , dummy DUMMY_COLUMN_NUMBER_914
     , dummy DUMMY_COLUMN_NUMBER_915
     , dummy DUMMY_COLUMN_NUMBER_916
     , dummy DUMMY_COLUMN_NUMBER_917
     , dummy DUMMY_COLUMN_NUMBER_918
     , dummy DUMMY_COLUMN_NUMBER_919
     , dummy DUMMY_COLUMN_NUMBER_920
     , dummy DUMMY_COLUMN_NUMBER_921
     , dummy DUMMY_COLUMN_NUMBER_922
     , dummy DUMMY_COLUMN_NUMBER_923
     , dummy DUMMY_COLUMN_NUMBER_924
     , dummy DUMMY_COLUMN_NUMBER_925
     , dummy DUMMY_COLUMN_NUMBER_926
     , dummy DUMMY_COLUMN_NUMBER_927
     , dummy DUMMY_COLUMN_NUMBER_928
     , dummy DUMMY_COLUMN_NUMBER_929
     , dummy DUMMY_COLUMN_NUMBER_930
     , dummy DUMMY_COLUMN_NUMBER_931
     , dummy DUMMY_COLUMN_NUMBER_932
     , dummy DUMMY_COLUMN_NUMBER_933
     , dummy DUMMY_COLUMN_NUMBER_934
     , dummy DUMMY_COLUMN_NUMBER_935
     , dummy DUMMY_COLUMN_NUMBER_936
     , dummy DUMMY_COLUMN_NUMBER_937
     , dummy DUMMY_COLUMN_NUMBER_938
     , dummy DUMMY_COLUMN_NUMBER_939
     , dummy DUMMY_COLUMN_NUMBER_940
     , dummy DUMMY_COLUMN_NUMBER_941
     , dummy DUMMY_COLUMN_NUMBER_942
     , dummy DUMMY_COLUMN_NUMBER_943
     , dummy DUMMY_COLUMN_NUMBER_944
     , dummy DUMMY_COLUMN_NUMBER_945
     , dummy DUMMY_COLUMN_NUMBER_946
     , dummy DUMMY_COLUMN_NUMBER_947
     , dummy DUMMY_COLUMN_NUMBER_948
     , dummy DUMMY_COLUMN_NUMBER_949
     , dummy DUMMY_COLUMN_NUMBER_950
     , dummy DUMMY_COLUMN_NUMBER_951
     , dummy DUMMY_COLUMN_NUMBER_952
     , dummy DUMMY_COLUMN_NUMBER_953
     , dummy DUMMY_COLUMN_NUMBER_954
     , dummy DUMMY_COLUMN_NUMBER_955
     , dummy DUMMY_COLUMN_NUMBER_956
     , dummy DUMMY_COLUMN_NUMBER_957
     , dummy DUMMY_COLUMN_NUMBER_958
     , dummy DUMMY_COLUMN_NUMBER_959
     , dummy DUMMY_COLUMN_NUMBER_960
     , dummy DUMMY_COLUMN_NUMBER_961
     , dummy DUMMY_COLUMN_NUMBER_962
     , dummy DUMMY_COLUMN_NUMBER_963
     , dummy DUMMY_COLUMN_NUMBER_964
     , dummy DUMMY_COLUMN_NUMBER_965
     , dummy DUMMY_COLUMN_NUMBER_966
     , dummy DUMMY_COLUMN_NUMBER_967
     , dummy DUMMY_COLUMN_NUMBER_968
     , dummy DUMMY_COLUMN_NUMBER_969
     , dummy DUMMY_COLUMN_NUMBER_970
     , dummy DUMMY_COLUMN_NUMBER_971
     , dummy DUMMY_COLUMN_NUMBER_972
     , dummy DUMMY_COLUMN_NUMBER_973
     , dummy DUMMY_COLUMN_NUMBER_974
     , dummy DUMMY_COLUMN_NUMBER_975
     , dummy DUMMY_COLUMN_NUMBER_976
     , dummy DUMMY_COLUMN_NUMBER_977
     , dummy DUMMY_COLUMN_NUMBER_978
     , dummy DUMMY_COLUMN_NUMBER_979
     , dummy DUMMY_COLUMN_NUMBER_980
     , dummy DUMMY_COLUMN_NUMBER_981
     , dummy DUMMY_COLUMN_NUMBER_982
     , dummy DUMMY_COLUMN_NUMBER_983
     , dummy DUMMY_COLUMN_NUMBER_984
     , dummy DUMMY_COLUMN_NUMBER_985
     , dummy DUMMY_COLUMN_NUMBER_986
     , dummy DUMMY_COLUMN_NUMBER_987
     , dummy DUMMY_COLUMN_NUMBER_988
     , dummy DUMMY_COLUMN_NUMBER_989
     , dummy DUMMY_COLUMN_NUMBER_990
     , dummy DUMMY_COLUMN_NUMBER_991
     , dummy DUMMY_COLUMN_NUMBER_992
     , dummy DUMMY_COLUMN_NUMBER_993
     , dummy DUMMY_COLUMN_NUMBER_994
     , dummy DUMMY_COLUMN_NUMBER_995
     , dummy DUMMY_COLUMN_NUMBER_996
     , dummy DUMMY_COLUMN_NUMBER_997
     , dummy DUMMY_COLUMN_NUMBER_998
     , dummy DUMMY_COLUMN_NUMBER_999
     , dummy DUMMY_COLUMN_NUMBER_1000
     , dummy DUMMY_COLUMN_NUMBER_1001
     , dummy DUMMY_COLUMN_NUMBER_1002
     , dummy DUMMY_COLUMN_NUMBER_1003
     , dummy DUMMY_COLUMN_NUMBER_1004
     , dummy DUMMY_COLUMN_NUMBER_1005
     , dummy DUMMY_COLUMN_NUMBER_1006
     , dummy DUMMY_COLUMN_NUMBER_1007
     , dummy DUMMY_COLUMN_NUMBER_1008
     , dummy DUMMY_COLUMN_NUMBER_1009
     , dummy DUMMY_COLUMN_NUMBER_1010
     , dummy DUMMY_COLUMN_NUMBER_1011
     , dummy DUMMY_COLUMN_NUMBER_1012
     , dummy DUMMY_COLUMN_NUMBER_1013
     , dummy DUMMY_COLUMN_NUMBER_1014
     , dummy DUMMY_COLUMN_NUMBER_1015
     , dummy DUMMY_COLUMN_NUMBER_1016
     , dummy DUMMY_COLUMN_NUMBER_1017
     , dummy DUMMY_COLUMN_NUMBER_1018
     , dummy DUMMY_COLUMN_NUMBER_1019
     , dummy DUMMY_COLUMN_NUMBER_1020
     , dummy DUMMY_COLUMN_NUMBER_1021
     , dummy DUMMY_COLUMN_NUMBER_1022
     , dummy DUMMY_COLUMN_NUMBER_1023
     , dummy DUMMY_COLUMN_NUMBER_1024
from dual
    }';
  
    dbms_utility.expand_sql_text(
        input_sql_text => v_input
      , output_sql_text => v_output
    );
  
    dbms_output.put_line(v_output);
  
  $end
end;
/

Instead, try breaking up your query into chunks using TO_CLOB(). Below, you’ll notice the TO_CLOB() at the start of the query, and at column numbers 200, 400, 600, and 800.

set serveroutput on;

declare
  v_input clob;
  v_output clob;
  v_firstloop boolean := true;
begin
  $if dbms_db_version.ver_le_9
      or dbms_db_version.ver_le_10 
      or dbms_db_version.ver_le_11 
  $then
    dbms_output.put_line('DBMS_UTILITY.EXPAND_SQL_TEXT requires Oracle 12c or above!');
  $else
    v_input := TO_CLOB(q'{ 
       select dummy DUMMY_COLUMN_NUMBER_0
     , dummy DUMMY_COLUMN_NUMBER_1
     , dummy DUMMY_COLUMN_NUMBER_2
     , dummy DUMMY_COLUMN_NUMBER_3
     , dummy DUMMY_COLUMN_NUMBER_4
     , dummy DUMMY_COLUMN_NUMBER_5
     , dummy DUMMY_COLUMN_NUMBER_6
     , dummy DUMMY_COLUMN_NUMBER_7
     , dummy DUMMY_COLUMN_NUMBER_8
     , dummy DUMMY_COLUMN_NUMBER_9
     , dummy DUMMY_COLUMN_NUMBER_10
     , dummy DUMMY_COLUMN_NUMBER_11
     , dummy DUMMY_COLUMN_NUMBER_12
     , dummy DUMMY_COLUMN_NUMBER_13
     , dummy DUMMY_COLUMN_NUMBER_14
     , dummy DUMMY_COLUMN_NUMBER_15
     , dummy DUMMY_COLUMN_NUMBER_16
     , dummy DUMMY_COLUMN_NUMBER_17
     , dummy DUMMY_COLUMN_NUMBER_18
     , dummy DUMMY_COLUMN_NUMBER_19
     , dummy DUMMY_COLUMN_NUMBER_20
     , dummy DUMMY_COLUMN_NUMBER_21
     , dummy DUMMY_COLUMN_NUMBER_22
     , dummy DUMMY_COLUMN_NUMBER_23
     , dummy DUMMY_COLUMN_NUMBER_24
     , dummy DUMMY_COLUMN_NUMBER_25
     , dummy DUMMY_COLUMN_NUMBER_26
     , dummy DUMMY_COLUMN_NUMBER_27
     , dummy DUMMY_COLUMN_NUMBER_28
     , dummy DUMMY_COLUMN_NUMBER_29
     , dummy DUMMY_COLUMN_NUMBER_30
     , dummy DUMMY_COLUMN_NUMBER_31
     , dummy DUMMY_COLUMN_NUMBER_32
     , dummy DUMMY_COLUMN_NUMBER_33
     , dummy DUMMY_COLUMN_NUMBER_34
     , dummy DUMMY_COLUMN_NUMBER_35
     , dummy DUMMY_COLUMN_NUMBER_36
     , dummy DUMMY_COLUMN_NUMBER_37
     , dummy DUMMY_COLUMN_NUMBER_38
     , dummy DUMMY_COLUMN_NUMBER_39
     , dummy DUMMY_COLUMN_NUMBER_40
     , dummy DUMMY_COLUMN_NUMBER_41
     , dummy DUMMY_COLUMN_NUMBER_42
     , dummy DUMMY_COLUMN_NUMBER_43
     , dummy DUMMY_COLUMN_NUMBER_44
     , dummy DUMMY_COLUMN_NUMBER_45
     , dummy DUMMY_COLUMN_NUMBER_46
     , dummy DUMMY_COLUMN_NUMBER_47
     , dummy DUMMY_COLUMN_NUMBER_48
     , dummy DUMMY_COLUMN_NUMBER_49
     , dummy DUMMY_COLUMN_NUMBER_50
     , dummy DUMMY_COLUMN_NUMBER_51
     , dummy DUMMY_COLUMN_NUMBER_52
     , dummy DUMMY_COLUMN_NUMBER_53
     , dummy DUMMY_COLUMN_NUMBER_54
     , dummy DUMMY_COLUMN_NUMBER_55
     , dummy DUMMY_COLUMN_NUMBER_56
     , dummy DUMMY_COLUMN_NUMBER_57
     , dummy DUMMY_COLUMN_NUMBER_58
     , dummy DUMMY_COLUMN_NUMBER_59
     , dummy DUMMY_COLUMN_NUMBER_60
     , dummy DUMMY_COLUMN_NUMBER_61
     , dummy DUMMY_COLUMN_NUMBER_62
     , dummy DUMMY_COLUMN_NUMBER_63
     , dummy DUMMY_COLUMN_NUMBER_64
     , dummy DUMMY_COLUMN_NUMBER_65
     , dummy DUMMY_COLUMN_NUMBER_66
     , dummy DUMMY_COLUMN_NUMBER_67
     , dummy DUMMY_COLUMN_NUMBER_68
     , dummy DUMMY_COLUMN_NUMBER_69
     , dummy DUMMY_COLUMN_NUMBER_70
     , dummy DUMMY_COLUMN_NUMBER_71
     , dummy DUMMY_COLUMN_NUMBER_72
     , dummy DUMMY_COLUMN_NUMBER_73
     , dummy DUMMY_COLUMN_NUMBER_74
     , dummy DUMMY_COLUMN_NUMBER_75
     , dummy DUMMY_COLUMN_NUMBER_76
     , dummy DUMMY_COLUMN_NUMBER_77
     , dummy DUMMY_COLUMN_NUMBER_78
     , dummy DUMMY_COLUMN_NUMBER_79
     , dummy DUMMY_COLUMN_NUMBER_80
     , dummy DUMMY_COLUMN_NUMBER_81
     , dummy DUMMY_COLUMN_NUMBER_82
     , dummy DUMMY_COLUMN_NUMBER_83
     , dummy DUMMY_COLUMN_NUMBER_84
     , dummy DUMMY_COLUMN_NUMBER_85
     , dummy DUMMY_COLUMN_NUMBER_86
     , dummy DUMMY_COLUMN_NUMBER_87
     , dummy DUMMY_COLUMN_NUMBER_88
     , dummy DUMMY_COLUMN_NUMBER_89
     , dummy DUMMY_COLUMN_NUMBER_90
     , dummy DUMMY_COLUMN_NUMBER_91
     , dummy DUMMY_COLUMN_NUMBER_92
     , dummy DUMMY_COLUMN_NUMBER_93
     , dummy DUMMY_COLUMN_NUMBER_94
     , dummy DUMMY_COLUMN_NUMBER_95
     , dummy DUMMY_COLUMN_NUMBER_96
     , dummy DUMMY_COLUMN_NUMBER_97
     , dummy DUMMY_COLUMN_NUMBER_98
     , dummy DUMMY_COLUMN_NUMBER_99
     , dummy DUMMY_COLUMN_NUMBER_100
     , dummy DUMMY_COLUMN_NUMBER_101
     , dummy DUMMY_COLUMN_NUMBER_102
     , dummy DUMMY_COLUMN_NUMBER_103
     , dummy DUMMY_COLUMN_NUMBER_104
     , dummy DUMMY_COLUMN_NUMBER_105
     , dummy DUMMY_COLUMN_NUMBER_106
     , dummy DUMMY_COLUMN_NUMBER_107
     , dummy DUMMY_COLUMN_NUMBER_108
     , dummy DUMMY_COLUMN_NUMBER_109
     , dummy DUMMY_COLUMN_NUMBER_110
     , dummy DUMMY_COLUMN_NUMBER_111
     , dummy DUMMY_COLUMN_NUMBER_112
     , dummy DUMMY_COLUMN_NUMBER_113
     , dummy DUMMY_COLUMN_NUMBER_114
     , dummy DUMMY_COLUMN_NUMBER_115
     , dummy DUMMY_COLUMN_NUMBER_116
     , dummy DUMMY_COLUMN_NUMBER_117
     , dummy DUMMY_COLUMN_NUMBER_118
     , dummy DUMMY_COLUMN_NUMBER_119
     , dummy DUMMY_COLUMN_NUMBER_120
     , dummy DUMMY_COLUMN_NUMBER_121
     , dummy DUMMY_COLUMN_NUMBER_122
     , dummy DUMMY_COLUMN_NUMBER_123
     , dummy DUMMY_COLUMN_NUMBER_124
     , dummy DUMMY_COLUMN_NUMBER_125
     , dummy DUMMY_COLUMN_NUMBER_126
     , dummy DUMMY_COLUMN_NUMBER_127
     , dummy DUMMY_COLUMN_NUMBER_128
     , dummy DUMMY_COLUMN_NUMBER_129
     , dummy DUMMY_COLUMN_NUMBER_130
     , dummy DUMMY_COLUMN_NUMBER_131
     , dummy DUMMY_COLUMN_NUMBER_132
     , dummy DUMMY_COLUMN_NUMBER_133
     , dummy DUMMY_COLUMN_NUMBER_134
     , dummy DUMMY_COLUMN_NUMBER_135
     , dummy DUMMY_COLUMN_NUMBER_136
     , dummy DUMMY_COLUMN_NUMBER_137
     , dummy DUMMY_COLUMN_NUMBER_138
     , dummy DUMMY_COLUMN_NUMBER_139
     , dummy DUMMY_COLUMN_NUMBER_140
     , dummy DUMMY_COLUMN_NUMBER_141
     , dummy DUMMY_COLUMN_NUMBER_142
     , dummy DUMMY_COLUMN_NUMBER_143
     , dummy DUMMY_COLUMN_NUMBER_144
     , dummy DUMMY_COLUMN_NUMBER_145
     , dummy DUMMY_COLUMN_NUMBER_146
     , dummy DUMMY_COLUMN_NUMBER_147
     , dummy DUMMY_COLUMN_NUMBER_148
     , dummy DUMMY_COLUMN_NUMBER_149
     , dummy DUMMY_COLUMN_NUMBER_150
     , dummy DUMMY_COLUMN_NUMBER_151
     , dummy DUMMY_COLUMN_NUMBER_152
     , dummy DUMMY_COLUMN_NUMBER_153
     , dummy DUMMY_COLUMN_NUMBER_154
     , dummy DUMMY_COLUMN_NUMBER_155
     , dummy DUMMY_COLUMN_NUMBER_156
     , dummy DUMMY_COLUMN_NUMBER_157
     , dummy DUMMY_COLUMN_NUMBER_158
     , dummy DUMMY_COLUMN_NUMBER_159
     , dummy DUMMY_COLUMN_NUMBER_160
     , dummy DUMMY_COLUMN_NUMBER_161
     , dummy DUMMY_COLUMN_NUMBER_162
     , dummy DUMMY_COLUMN_NUMBER_163
     , dummy DUMMY_COLUMN_NUMBER_164
     , dummy DUMMY_COLUMN_NUMBER_165
     , dummy DUMMY_COLUMN_NUMBER_166
     , dummy DUMMY_COLUMN_NUMBER_167
     , dummy DUMMY_COLUMN_NUMBER_168
     , dummy DUMMY_COLUMN_NUMBER_169
     , dummy DUMMY_COLUMN_NUMBER_170
     , dummy DUMMY_COLUMN_NUMBER_171
     , dummy DUMMY_COLUMN_NUMBER_172
     , dummy DUMMY_COLUMN_NUMBER_173
     , dummy DUMMY_COLUMN_NUMBER_174
     , dummy DUMMY_COLUMN_NUMBER_175
     , dummy DUMMY_COLUMN_NUMBER_176
     , dummy DUMMY_COLUMN_NUMBER_177
     , dummy DUMMY_COLUMN_NUMBER_178
     , dummy DUMMY_COLUMN_NUMBER_179
     , dummy DUMMY_COLUMN_NUMBER_180
     , dummy DUMMY_COLUMN_NUMBER_181
     , dummy DUMMY_COLUMN_NUMBER_182
     , dummy DUMMY_COLUMN_NUMBER_183
     , dummy DUMMY_COLUMN_NUMBER_184
     , dummy DUMMY_COLUMN_NUMBER_185
     , dummy DUMMY_COLUMN_NUMBER_186
     , dummy DUMMY_COLUMN_NUMBER_187
     , dummy DUMMY_COLUMN_NUMBER_188
     , dummy DUMMY_COLUMN_NUMBER_189
     , dummy DUMMY_COLUMN_NUMBER_190
     , dummy DUMMY_COLUMN_NUMBER_191
     , dummy DUMMY_COLUMN_NUMBER_192
     , dummy DUMMY_COLUMN_NUMBER_193
     , dummy DUMMY_COLUMN_NUMBER_194
     , dummy DUMMY_COLUMN_NUMBER_195
     , dummy DUMMY_COLUMN_NUMBER_196
     , dummy DUMMY_COLUMN_NUMBER_197
     , dummy DUMMY_COLUMN_NUMBER_198
     , dummy DUMMY_COLUMN_NUMBER_199
     , dummy DUMMY_COLUMN_NUMBER_200}') || TO_CLOB(q'{
     , dummy DUMMY_COLUMN_NUMBER_201
     , dummy DUMMY_COLUMN_NUMBER_202
     , dummy DUMMY_COLUMN_NUMBER_203
     , dummy DUMMY_COLUMN_NUMBER_204
     , dummy DUMMY_COLUMN_NUMBER_205
     , dummy DUMMY_COLUMN_NUMBER_206
     , dummy DUMMY_COLUMN_NUMBER_207
     , dummy DUMMY_COLUMN_NUMBER_208
     , dummy DUMMY_COLUMN_NUMBER_209
     , dummy DUMMY_COLUMN_NUMBER_210
     , dummy DUMMY_COLUMN_NUMBER_211
     , dummy DUMMY_COLUMN_NUMBER_212
     , dummy DUMMY_COLUMN_NUMBER_213
     , dummy DUMMY_COLUMN_NUMBER_214
     , dummy DUMMY_COLUMN_NUMBER_215
     , dummy DUMMY_COLUMN_NUMBER_216
     , dummy DUMMY_COLUMN_NUMBER_217
     , dummy DUMMY_COLUMN_NUMBER_218
     , dummy DUMMY_COLUMN_NUMBER_219
     , dummy DUMMY_COLUMN_NUMBER_220
     , dummy DUMMY_COLUMN_NUMBER_221
     , dummy DUMMY_COLUMN_NUMBER_222
     , dummy DUMMY_COLUMN_NUMBER_223
     , dummy DUMMY_COLUMN_NUMBER_224
     , dummy DUMMY_COLUMN_NUMBER_225
     , dummy DUMMY_COLUMN_NUMBER_226
     , dummy DUMMY_COLUMN_NUMBER_227
     , dummy DUMMY_COLUMN_NUMBER_228
     , dummy DUMMY_COLUMN_NUMBER_229
     , dummy DUMMY_COLUMN_NUMBER_230
     , dummy DUMMY_COLUMN_NUMBER_231
     , dummy DUMMY_COLUMN_NUMBER_232
     , dummy DUMMY_COLUMN_NUMBER_233
     , dummy DUMMY_COLUMN_NUMBER_234
     , dummy DUMMY_COLUMN_NUMBER_235
     , dummy DUMMY_COLUMN_NUMBER_236
     , dummy DUMMY_COLUMN_NUMBER_237
     , dummy DUMMY_COLUMN_NUMBER_238
     , dummy DUMMY_COLUMN_NUMBER_239
     , dummy DUMMY_COLUMN_NUMBER_240
     , dummy DUMMY_COLUMN_NUMBER_241
     , dummy DUMMY_COLUMN_NUMBER_242
     , dummy DUMMY_COLUMN_NUMBER_243
     , dummy DUMMY_COLUMN_NUMBER_244
     , dummy DUMMY_COLUMN_NUMBER_245
     , dummy DUMMY_COLUMN_NUMBER_246
     , dummy DUMMY_COLUMN_NUMBER_247
     , dummy DUMMY_COLUMN_NUMBER_248
     , dummy DUMMY_COLUMN_NUMBER_249
     , dummy DUMMY_COLUMN_NUMBER_250
     , dummy DUMMY_COLUMN_NUMBER_251
     , dummy DUMMY_COLUMN_NUMBER_252
     , dummy DUMMY_COLUMN_NUMBER_253
     , dummy DUMMY_COLUMN_NUMBER_254
     , dummy DUMMY_COLUMN_NUMBER_255
     , dummy DUMMY_COLUMN_NUMBER_256
     , dummy DUMMY_COLUMN_NUMBER_257
     , dummy DUMMY_COLUMN_NUMBER_258
     , dummy DUMMY_COLUMN_NUMBER_259
     , dummy DUMMY_COLUMN_NUMBER_260
     , dummy DUMMY_COLUMN_NUMBER_261
     , dummy DUMMY_COLUMN_NUMBER_262
     , dummy DUMMY_COLUMN_NUMBER_263
     , dummy DUMMY_COLUMN_NUMBER_264
     , dummy DUMMY_COLUMN_NUMBER_265
     , dummy DUMMY_COLUMN_NUMBER_266
     , dummy DUMMY_COLUMN_NUMBER_267
     , dummy DUMMY_COLUMN_NUMBER_268
     , dummy DUMMY_COLUMN_NUMBER_269
     , dummy DUMMY_COLUMN_NUMBER_270
     , dummy DUMMY_COLUMN_NUMBER_271
     , dummy DUMMY_COLUMN_NUMBER_272
     , dummy DUMMY_COLUMN_NUMBER_273
     , dummy DUMMY_COLUMN_NUMBER_274
     , dummy DUMMY_COLUMN_NUMBER_275
     , dummy DUMMY_COLUMN_NUMBER_276
     , dummy DUMMY_COLUMN_NUMBER_277
     , dummy DUMMY_COLUMN_NUMBER_278
     , dummy DUMMY_COLUMN_NUMBER_279
     , dummy DUMMY_COLUMN_NUMBER_280
     , dummy DUMMY_COLUMN_NUMBER_281
     , dummy DUMMY_COLUMN_NUMBER_282
     , dummy DUMMY_COLUMN_NUMBER_283
     , dummy DUMMY_COLUMN_NUMBER_284
     , dummy DUMMY_COLUMN_NUMBER_285
     , dummy DUMMY_COLUMN_NUMBER_286
     , dummy DUMMY_COLUMN_NUMBER_287
     , dummy DUMMY_COLUMN_NUMBER_288
     , dummy DUMMY_COLUMN_NUMBER_289
     , dummy DUMMY_COLUMN_NUMBER_290
     , dummy DUMMY_COLUMN_NUMBER_291
     , dummy DUMMY_COLUMN_NUMBER_292
     , dummy DUMMY_COLUMN_NUMBER_293
     , dummy DUMMY_COLUMN_NUMBER_294
     , dummy DUMMY_COLUMN_NUMBER_295
     , dummy DUMMY_COLUMN_NUMBER_296
     , dummy DUMMY_COLUMN_NUMBER_297
     , dummy DUMMY_COLUMN_NUMBER_298
     , dummy DUMMY_COLUMN_NUMBER_299
     , dummy DUMMY_COLUMN_NUMBER_300
     , dummy DUMMY_COLUMN_NUMBER_301
     , dummy DUMMY_COLUMN_NUMBER_302
     , dummy DUMMY_COLUMN_NUMBER_303
     , dummy DUMMY_COLUMN_NUMBER_304
     , dummy DUMMY_COLUMN_NUMBER_305
     , dummy DUMMY_COLUMN_NUMBER_306
     , dummy DUMMY_COLUMN_NUMBER_307
     , dummy DUMMY_COLUMN_NUMBER_308
     , dummy DUMMY_COLUMN_NUMBER_309
     , dummy DUMMY_COLUMN_NUMBER_310
     , dummy DUMMY_COLUMN_NUMBER_311
     , dummy DUMMY_COLUMN_NUMBER_312
     , dummy DUMMY_COLUMN_NUMBER_313
     , dummy DUMMY_COLUMN_NUMBER_314
     , dummy DUMMY_COLUMN_NUMBER_315
     , dummy DUMMY_COLUMN_NUMBER_316
     , dummy DUMMY_COLUMN_NUMBER_317
     , dummy DUMMY_COLUMN_NUMBER_318
     , dummy DUMMY_COLUMN_NUMBER_319
     , dummy DUMMY_COLUMN_NUMBER_320
     , dummy DUMMY_COLUMN_NUMBER_321
     , dummy DUMMY_COLUMN_NUMBER_322
     , dummy DUMMY_COLUMN_NUMBER_323
     , dummy DUMMY_COLUMN_NUMBER_324
     , dummy DUMMY_COLUMN_NUMBER_325
     , dummy DUMMY_COLUMN_NUMBER_326
     , dummy DUMMY_COLUMN_NUMBER_327
     , dummy DUMMY_COLUMN_NUMBER_328
     , dummy DUMMY_COLUMN_NUMBER_329
     , dummy DUMMY_COLUMN_NUMBER_330
     , dummy DUMMY_COLUMN_NUMBER_331
     , dummy DUMMY_COLUMN_NUMBER_332
     , dummy DUMMY_COLUMN_NUMBER_333
     , dummy DUMMY_COLUMN_NUMBER_334
     , dummy DUMMY_COLUMN_NUMBER_335
     , dummy DUMMY_COLUMN_NUMBER_336
     , dummy DUMMY_COLUMN_NUMBER_337
     , dummy DUMMY_COLUMN_NUMBER_338
     , dummy DUMMY_COLUMN_NUMBER_339
     , dummy DUMMY_COLUMN_NUMBER_340
     , dummy DUMMY_COLUMN_NUMBER_341
     , dummy DUMMY_COLUMN_NUMBER_342
     , dummy DUMMY_COLUMN_NUMBER_343
     , dummy DUMMY_COLUMN_NUMBER_344
     , dummy DUMMY_COLUMN_NUMBER_345
     , dummy DUMMY_COLUMN_NUMBER_346
     , dummy DUMMY_COLUMN_NUMBER_347
     , dummy DUMMY_COLUMN_NUMBER_348
     , dummy DUMMY_COLUMN_NUMBER_349
     , dummy DUMMY_COLUMN_NUMBER_350
     , dummy DUMMY_COLUMN_NUMBER_351
     , dummy DUMMY_COLUMN_NUMBER_352
     , dummy DUMMY_COLUMN_NUMBER_353
     , dummy DUMMY_COLUMN_NUMBER_354
     , dummy DUMMY_COLUMN_NUMBER_355
     , dummy DUMMY_COLUMN_NUMBER_356
     , dummy DUMMY_COLUMN_NUMBER_357
     , dummy DUMMY_COLUMN_NUMBER_358
     , dummy DUMMY_COLUMN_NUMBER_359
     , dummy DUMMY_COLUMN_NUMBER_360
     , dummy DUMMY_COLUMN_NUMBER_361
     , dummy DUMMY_COLUMN_NUMBER_362
     , dummy DUMMY_COLUMN_NUMBER_363
     , dummy DUMMY_COLUMN_NUMBER_364
     , dummy DUMMY_COLUMN_NUMBER_365
     , dummy DUMMY_COLUMN_NUMBER_366
     , dummy DUMMY_COLUMN_NUMBER_367
     , dummy DUMMY_COLUMN_NUMBER_368
     , dummy DUMMY_COLUMN_NUMBER_369
     , dummy DUMMY_COLUMN_NUMBER_370
     , dummy DUMMY_COLUMN_NUMBER_371
     , dummy DUMMY_COLUMN_NUMBER_372
     , dummy DUMMY_COLUMN_NUMBER_373
     , dummy DUMMY_COLUMN_NUMBER_374
     , dummy DUMMY_COLUMN_NUMBER_375
     , dummy DUMMY_COLUMN_NUMBER_376
     , dummy DUMMY_COLUMN_NUMBER_377
     , dummy DUMMY_COLUMN_NUMBER_378
     , dummy DUMMY_COLUMN_NUMBER_379
     , dummy DUMMY_COLUMN_NUMBER_380
     , dummy DUMMY_COLUMN_NUMBER_381
     , dummy DUMMY_COLUMN_NUMBER_382
     , dummy DUMMY_COLUMN_NUMBER_383
     , dummy DUMMY_COLUMN_NUMBER_384
     , dummy DUMMY_COLUMN_NUMBER_385
     , dummy DUMMY_COLUMN_NUMBER_386
     , dummy DUMMY_COLUMN_NUMBER_387
     , dummy DUMMY_COLUMN_NUMBER_388
     , dummy DUMMY_COLUMN_NUMBER_389
     , dummy DUMMY_COLUMN_NUMBER_390
     , dummy DUMMY_COLUMN_NUMBER_391
     , dummy DUMMY_COLUMN_NUMBER_392
     , dummy DUMMY_COLUMN_NUMBER_393
     , dummy DUMMY_COLUMN_NUMBER_394
     , dummy DUMMY_COLUMN_NUMBER_395
     , dummy DUMMY_COLUMN_NUMBER_396
     , dummy DUMMY_COLUMN_NUMBER_397
     , dummy DUMMY_COLUMN_NUMBER_398
     , dummy DUMMY_COLUMN_NUMBER_399
     , dummy DUMMY_COLUMN_NUMBER_400}') || TO_CLOB(q'{
     , dummy DUMMY_COLUMN_NUMBER_401
     , dummy DUMMY_COLUMN_NUMBER_402
     , dummy DUMMY_COLUMN_NUMBER_403
     , dummy DUMMY_COLUMN_NUMBER_404
     , dummy DUMMY_COLUMN_NUMBER_405
     , dummy DUMMY_COLUMN_NUMBER_406
     , dummy DUMMY_COLUMN_NUMBER_407
     , dummy DUMMY_COLUMN_NUMBER_408
     , dummy DUMMY_COLUMN_NUMBER_409
     , dummy DUMMY_COLUMN_NUMBER_410
     , dummy DUMMY_COLUMN_NUMBER_411
     , dummy DUMMY_COLUMN_NUMBER_412
     , dummy DUMMY_COLUMN_NUMBER_413
     , dummy DUMMY_COLUMN_NUMBER_414
     , dummy DUMMY_COLUMN_NUMBER_415
     , dummy DUMMY_COLUMN_NUMBER_416
     , dummy DUMMY_COLUMN_NUMBER_417
     , dummy DUMMY_COLUMN_NUMBER_418
     , dummy DUMMY_COLUMN_NUMBER_419
     , dummy DUMMY_COLUMN_NUMBER_420
     , dummy DUMMY_COLUMN_NUMBER_421
     , dummy DUMMY_COLUMN_NUMBER_422
     , dummy DUMMY_COLUMN_NUMBER_423
     , dummy DUMMY_COLUMN_NUMBER_424
     , dummy DUMMY_COLUMN_NUMBER_425
     , dummy DUMMY_COLUMN_NUMBER_426
     , dummy DUMMY_COLUMN_NUMBER_427
     , dummy DUMMY_COLUMN_NUMBER_428
     , dummy DUMMY_COLUMN_NUMBER_429
     , dummy DUMMY_COLUMN_NUMBER_430
     , dummy DUMMY_COLUMN_NUMBER_431
     , dummy DUMMY_COLUMN_NUMBER_432
     , dummy DUMMY_COLUMN_NUMBER_433
     , dummy DUMMY_COLUMN_NUMBER_434
     , dummy DUMMY_COLUMN_NUMBER_435
     , dummy DUMMY_COLUMN_NUMBER_436
     , dummy DUMMY_COLUMN_NUMBER_437
     , dummy DUMMY_COLUMN_NUMBER_438
     , dummy DUMMY_COLUMN_NUMBER_439
     , dummy DUMMY_COLUMN_NUMBER_440
     , dummy DUMMY_COLUMN_NUMBER_441
     , dummy DUMMY_COLUMN_NUMBER_442
     , dummy DUMMY_COLUMN_NUMBER_443
     , dummy DUMMY_COLUMN_NUMBER_444
     , dummy DUMMY_COLUMN_NUMBER_445
     , dummy DUMMY_COLUMN_NUMBER_446
     , dummy DUMMY_COLUMN_NUMBER_447
     , dummy DUMMY_COLUMN_NUMBER_448
     , dummy DUMMY_COLUMN_NUMBER_449
     , dummy DUMMY_COLUMN_NUMBER_450
     , dummy DUMMY_COLUMN_NUMBER_451
     , dummy DUMMY_COLUMN_NUMBER_452
     , dummy DUMMY_COLUMN_NUMBER_453
     , dummy DUMMY_COLUMN_NUMBER_454
     , dummy DUMMY_COLUMN_NUMBER_455
     , dummy DUMMY_COLUMN_NUMBER_456
     , dummy DUMMY_COLUMN_NUMBER_457
     , dummy DUMMY_COLUMN_NUMBER_458
     , dummy DUMMY_COLUMN_NUMBER_459
     , dummy DUMMY_COLUMN_NUMBER_460
     , dummy DUMMY_COLUMN_NUMBER_461
     , dummy DUMMY_COLUMN_NUMBER_462
     , dummy DUMMY_COLUMN_NUMBER_463
     , dummy DUMMY_COLUMN_NUMBER_464
     , dummy DUMMY_COLUMN_NUMBER_465
     , dummy DUMMY_COLUMN_NUMBER_466
     , dummy DUMMY_COLUMN_NUMBER_467
     , dummy DUMMY_COLUMN_NUMBER_468
     , dummy DUMMY_COLUMN_NUMBER_469
     , dummy DUMMY_COLUMN_NUMBER_470
     , dummy DUMMY_COLUMN_NUMBER_471
     , dummy DUMMY_COLUMN_NUMBER_472
     , dummy DUMMY_COLUMN_NUMBER_473
     , dummy DUMMY_COLUMN_NUMBER_474
     , dummy DUMMY_COLUMN_NUMBER_475
     , dummy DUMMY_COLUMN_NUMBER_476
     , dummy DUMMY_COLUMN_NUMBER_477
     , dummy DUMMY_COLUMN_NUMBER_478
     , dummy DUMMY_COLUMN_NUMBER_479
     , dummy DUMMY_COLUMN_NUMBER_480
     , dummy DUMMY_COLUMN_NUMBER_481
     , dummy DUMMY_COLUMN_NUMBER_482
     , dummy DUMMY_COLUMN_NUMBER_483
     , dummy DUMMY_COLUMN_NUMBER_484
     , dummy DUMMY_COLUMN_NUMBER_485
     , dummy DUMMY_COLUMN_NUMBER_486
     , dummy DUMMY_COLUMN_NUMBER_487
     , dummy DUMMY_COLUMN_NUMBER_488
     , dummy DUMMY_COLUMN_NUMBER_489
     , dummy DUMMY_COLUMN_NUMBER_490
     , dummy DUMMY_COLUMN_NUMBER_491
     , dummy DUMMY_COLUMN_NUMBER_492
     , dummy DUMMY_COLUMN_NUMBER_493
     , dummy DUMMY_COLUMN_NUMBER_494
     , dummy DUMMY_COLUMN_NUMBER_495
     , dummy DUMMY_COLUMN_NUMBER_496
     , dummy DUMMY_COLUMN_NUMBER_497
     , dummy DUMMY_COLUMN_NUMBER_498
     , dummy DUMMY_COLUMN_NUMBER_499
     , dummy DUMMY_COLUMN_NUMBER_500
     , dummy DUMMY_COLUMN_NUMBER_501
     , dummy DUMMY_COLUMN_NUMBER_502
     , dummy DUMMY_COLUMN_NUMBER_503
     , dummy DUMMY_COLUMN_NUMBER_504
     , dummy DUMMY_COLUMN_NUMBER_505
     , dummy DUMMY_COLUMN_NUMBER_506
     , dummy DUMMY_COLUMN_NUMBER_507
     , dummy DUMMY_COLUMN_NUMBER_508
     , dummy DUMMY_COLUMN_NUMBER_509
     , dummy DUMMY_COLUMN_NUMBER_510
     , dummy DUMMY_COLUMN_NUMBER_511
     , dummy DUMMY_COLUMN_NUMBER_512
     , dummy DUMMY_COLUMN_NUMBER_513
     , dummy DUMMY_COLUMN_NUMBER_514
     , dummy DUMMY_COLUMN_NUMBER_515
     , dummy DUMMY_COLUMN_NUMBER_516
     , dummy DUMMY_COLUMN_NUMBER_517
     , dummy DUMMY_COLUMN_NUMBER_518
     , dummy DUMMY_COLUMN_NUMBER_519
     , dummy DUMMY_COLUMN_NUMBER_520
     , dummy DUMMY_COLUMN_NUMBER_521
     , dummy DUMMY_COLUMN_NUMBER_522
     , dummy DUMMY_COLUMN_NUMBER_523
     , dummy DUMMY_COLUMN_NUMBER_524
     , dummy DUMMY_COLUMN_NUMBER_525
     , dummy DUMMY_COLUMN_NUMBER_526
     , dummy DUMMY_COLUMN_NUMBER_527
     , dummy DUMMY_COLUMN_NUMBER_528
     , dummy DUMMY_COLUMN_NUMBER_529
     , dummy DUMMY_COLUMN_NUMBER_530
     , dummy DUMMY_COLUMN_NUMBER_531
     , dummy DUMMY_COLUMN_NUMBER_532
     , dummy DUMMY_COLUMN_NUMBER_533
     , dummy DUMMY_COLUMN_NUMBER_534
     , dummy DUMMY_COLUMN_NUMBER_535
     , dummy DUMMY_COLUMN_NUMBER_536
     , dummy DUMMY_COLUMN_NUMBER_537
     , dummy DUMMY_COLUMN_NUMBER_538
     , dummy DUMMY_COLUMN_NUMBER_539
     , dummy DUMMY_COLUMN_NUMBER_540
     , dummy DUMMY_COLUMN_NUMBER_541
     , dummy DUMMY_COLUMN_NUMBER_542
     , dummy DUMMY_COLUMN_NUMBER_543
     , dummy DUMMY_COLUMN_NUMBER_544
     , dummy DUMMY_COLUMN_NUMBER_545
     , dummy DUMMY_COLUMN_NUMBER_546
     , dummy DUMMY_COLUMN_NUMBER_547
     , dummy DUMMY_COLUMN_NUMBER_548
     , dummy DUMMY_COLUMN_NUMBER_549
     , dummy DUMMY_COLUMN_NUMBER_550
     , dummy DUMMY_COLUMN_NUMBER_551
     , dummy DUMMY_COLUMN_NUMBER_552
     , dummy DUMMY_COLUMN_NUMBER_553
     , dummy DUMMY_COLUMN_NUMBER_554
     , dummy DUMMY_COLUMN_NUMBER_555
     , dummy DUMMY_COLUMN_NUMBER_556
     , dummy DUMMY_COLUMN_NUMBER_557
     , dummy DUMMY_COLUMN_NUMBER_558
     , dummy DUMMY_COLUMN_NUMBER_559
     , dummy DUMMY_COLUMN_NUMBER_560
     , dummy DUMMY_COLUMN_NUMBER_561
     , dummy DUMMY_COLUMN_NUMBER_562
     , dummy DUMMY_COLUMN_NUMBER_563
     , dummy DUMMY_COLUMN_NUMBER_564
     , dummy DUMMY_COLUMN_NUMBER_565
     , dummy DUMMY_COLUMN_NUMBER_566
     , dummy DUMMY_COLUMN_NUMBER_567
     , dummy DUMMY_COLUMN_NUMBER_568
     , dummy DUMMY_COLUMN_NUMBER_569
     , dummy DUMMY_COLUMN_NUMBER_570
     , dummy DUMMY_COLUMN_NUMBER_571
     , dummy DUMMY_COLUMN_NUMBER_572
     , dummy DUMMY_COLUMN_NUMBER_573
     , dummy DUMMY_COLUMN_NUMBER_574
     , dummy DUMMY_COLUMN_NUMBER_575
     , dummy DUMMY_COLUMN_NUMBER_576
     , dummy DUMMY_COLUMN_NUMBER_577
     , dummy DUMMY_COLUMN_NUMBER_578
     , dummy DUMMY_COLUMN_NUMBER_579
     , dummy DUMMY_COLUMN_NUMBER_580
     , dummy DUMMY_COLUMN_NUMBER_581
     , dummy DUMMY_COLUMN_NUMBER_582
     , dummy DUMMY_COLUMN_NUMBER_583
     , dummy DUMMY_COLUMN_NUMBER_584
     , dummy DUMMY_COLUMN_NUMBER_585
     , dummy DUMMY_COLUMN_NUMBER_586
     , dummy DUMMY_COLUMN_NUMBER_587
     , dummy DUMMY_COLUMN_NUMBER_588
     , dummy DUMMY_COLUMN_NUMBER_589
     , dummy DUMMY_COLUMN_NUMBER_590
     , dummy DUMMY_COLUMN_NUMBER_591
     , dummy DUMMY_COLUMN_NUMBER_592
     , dummy DUMMY_COLUMN_NUMBER_593
     , dummy DUMMY_COLUMN_NUMBER_594
     , dummy DUMMY_COLUMN_NUMBER_595
     , dummy DUMMY_COLUMN_NUMBER_596
     , dummy DUMMY_COLUMN_NUMBER_597
     , dummy DUMMY_COLUMN_NUMBER_598
     , dummy DUMMY_COLUMN_NUMBER_599
     , dummy DUMMY_COLUMN_NUMBER_600}') || TO_CLOB(q'{
     , dummy DUMMY_COLUMN_NUMBER_601
     , dummy DUMMY_COLUMN_NUMBER_602
     , dummy DUMMY_COLUMN_NUMBER_603
     , dummy DUMMY_COLUMN_NUMBER_604
     , dummy DUMMY_COLUMN_NUMBER_605
     , dummy DUMMY_COLUMN_NUMBER_606
     , dummy DUMMY_COLUMN_NUMBER_607
     , dummy DUMMY_COLUMN_NUMBER_608
     , dummy DUMMY_COLUMN_NUMBER_609
     , dummy DUMMY_COLUMN_NUMBER_610
     , dummy DUMMY_COLUMN_NUMBER_611
     , dummy DUMMY_COLUMN_NUMBER_612
     , dummy DUMMY_COLUMN_NUMBER_613
     , dummy DUMMY_COLUMN_NUMBER_614
     , dummy DUMMY_COLUMN_NUMBER_615
     , dummy DUMMY_COLUMN_NUMBER_616
     , dummy DUMMY_COLUMN_NUMBER_617
     , dummy DUMMY_COLUMN_NUMBER_618
     , dummy DUMMY_COLUMN_NUMBER_619
     , dummy DUMMY_COLUMN_NUMBER_620
     , dummy DUMMY_COLUMN_NUMBER_621
     , dummy DUMMY_COLUMN_NUMBER_622
     , dummy DUMMY_COLUMN_NUMBER_623
     , dummy DUMMY_COLUMN_NUMBER_624
     , dummy DUMMY_COLUMN_NUMBER_625
     , dummy DUMMY_COLUMN_NUMBER_626
     , dummy DUMMY_COLUMN_NUMBER_627
     , dummy DUMMY_COLUMN_NUMBER_628
     , dummy DUMMY_COLUMN_NUMBER_629
     , dummy DUMMY_COLUMN_NUMBER_630
     , dummy DUMMY_COLUMN_NUMBER_631
     , dummy DUMMY_COLUMN_NUMBER_632
     , dummy DUMMY_COLUMN_NUMBER_633
     , dummy DUMMY_COLUMN_NUMBER_634
     , dummy DUMMY_COLUMN_NUMBER_635
     , dummy DUMMY_COLUMN_NUMBER_636
     , dummy DUMMY_COLUMN_NUMBER_637
     , dummy DUMMY_COLUMN_NUMBER_638
     , dummy DUMMY_COLUMN_NUMBER_639
     , dummy DUMMY_COLUMN_NUMBER_640
     , dummy DUMMY_COLUMN_NUMBER_641
     , dummy DUMMY_COLUMN_NUMBER_642
     , dummy DUMMY_COLUMN_NUMBER_643
     , dummy DUMMY_COLUMN_NUMBER_644
     , dummy DUMMY_COLUMN_NUMBER_645
     , dummy DUMMY_COLUMN_NUMBER_646
     , dummy DUMMY_COLUMN_NUMBER_647
     , dummy DUMMY_COLUMN_NUMBER_648
     , dummy DUMMY_COLUMN_NUMBER_649
     , dummy DUMMY_COLUMN_NUMBER_650
     , dummy DUMMY_COLUMN_NUMBER_651
     , dummy DUMMY_COLUMN_NUMBER_652
     , dummy DUMMY_COLUMN_NUMBER_653
     , dummy DUMMY_COLUMN_NUMBER_654
     , dummy DUMMY_COLUMN_NUMBER_655
     , dummy DUMMY_COLUMN_NUMBER_656
     , dummy DUMMY_COLUMN_NUMBER_657
     , dummy DUMMY_COLUMN_NUMBER_658
     , dummy DUMMY_COLUMN_NUMBER_659
     , dummy DUMMY_COLUMN_NUMBER_660
     , dummy DUMMY_COLUMN_NUMBER_661
     , dummy DUMMY_COLUMN_NUMBER_662
     , dummy DUMMY_COLUMN_NUMBER_663
     , dummy DUMMY_COLUMN_NUMBER_664
     , dummy DUMMY_COLUMN_NUMBER_665
     , dummy DUMMY_COLUMN_NUMBER_666
     , dummy DUMMY_COLUMN_NUMBER_667
     , dummy DUMMY_COLUMN_NUMBER_668
     , dummy DUMMY_COLUMN_NUMBER_669
     , dummy DUMMY_COLUMN_NUMBER_670
     , dummy DUMMY_COLUMN_NUMBER_671
     , dummy DUMMY_COLUMN_NUMBER_672
     , dummy DUMMY_COLUMN_NUMBER_673
     , dummy DUMMY_COLUMN_NUMBER_674
     , dummy DUMMY_COLUMN_NUMBER_675
     , dummy DUMMY_COLUMN_NUMBER_676
     , dummy DUMMY_COLUMN_NUMBER_677
     , dummy DUMMY_COLUMN_NUMBER_678
     , dummy DUMMY_COLUMN_NUMBER_679
     , dummy DUMMY_COLUMN_NUMBER_680
     , dummy DUMMY_COLUMN_NUMBER_681
     , dummy DUMMY_COLUMN_NUMBER_682
     , dummy DUMMY_COLUMN_NUMBER_683
     , dummy DUMMY_COLUMN_NUMBER_684
     , dummy DUMMY_COLUMN_NUMBER_685
     , dummy DUMMY_COLUMN_NUMBER_686
     , dummy DUMMY_COLUMN_NUMBER_687
     , dummy DUMMY_COLUMN_NUMBER_688
     , dummy DUMMY_COLUMN_NUMBER_689
     , dummy DUMMY_COLUMN_NUMBER_690
     , dummy DUMMY_COLUMN_NUMBER_691
     , dummy DUMMY_COLUMN_NUMBER_692
     , dummy DUMMY_COLUMN_NUMBER_693
     , dummy DUMMY_COLUMN_NUMBER_694
     , dummy DUMMY_COLUMN_NUMBER_695
     , dummy DUMMY_COLUMN_NUMBER_696
     , dummy DUMMY_COLUMN_NUMBER_697
     , dummy DUMMY_COLUMN_NUMBER_698
     , dummy DUMMY_COLUMN_NUMBER_699
     , dummy DUMMY_COLUMN_NUMBER_700
     , dummy DUMMY_COLUMN_NUMBER_701
     , dummy DUMMY_COLUMN_NUMBER_702
     , dummy DUMMY_COLUMN_NUMBER_703
     , dummy DUMMY_COLUMN_NUMBER_704
     , dummy DUMMY_COLUMN_NUMBER_705
     , dummy DUMMY_COLUMN_NUMBER_706
     , dummy DUMMY_COLUMN_NUMBER_707
     , dummy DUMMY_COLUMN_NUMBER_708
     , dummy DUMMY_COLUMN_NUMBER_709
     , dummy DUMMY_COLUMN_NUMBER_710
     , dummy DUMMY_COLUMN_NUMBER_711
     , dummy DUMMY_COLUMN_NUMBER_712
     , dummy DUMMY_COLUMN_NUMBER_713
     , dummy DUMMY_COLUMN_NUMBER_714
     , dummy DUMMY_COLUMN_NUMBER_715
     , dummy DUMMY_COLUMN_NUMBER_716
     , dummy DUMMY_COLUMN_NUMBER_717
     , dummy DUMMY_COLUMN_NUMBER_718
     , dummy DUMMY_COLUMN_NUMBER_719
     , dummy DUMMY_COLUMN_NUMBER_720
     , dummy DUMMY_COLUMN_NUMBER_721
     , dummy DUMMY_COLUMN_NUMBER_722
     , dummy DUMMY_COLUMN_NUMBER_723
     , dummy DUMMY_COLUMN_NUMBER_724
     , dummy DUMMY_COLUMN_NUMBER_725
     , dummy DUMMY_COLUMN_NUMBER_726
     , dummy DUMMY_COLUMN_NUMBER_727
     , dummy DUMMY_COLUMN_NUMBER_728
     , dummy DUMMY_COLUMN_NUMBER_729
     , dummy DUMMY_COLUMN_NUMBER_730
     , dummy DUMMY_COLUMN_NUMBER_731
     , dummy DUMMY_COLUMN_NUMBER_732
     , dummy DUMMY_COLUMN_NUMBER_733
     , dummy DUMMY_COLUMN_NUMBER_734
     , dummy DUMMY_COLUMN_NUMBER_735
     , dummy DUMMY_COLUMN_NUMBER_736
     , dummy DUMMY_COLUMN_NUMBER_737
     , dummy DUMMY_COLUMN_NUMBER_738
     , dummy DUMMY_COLUMN_NUMBER_739
     , dummy DUMMY_COLUMN_NUMBER_740
     , dummy DUMMY_COLUMN_NUMBER_741
     , dummy DUMMY_COLUMN_NUMBER_742
     , dummy DUMMY_COLUMN_NUMBER_743
     , dummy DUMMY_COLUMN_NUMBER_744
     , dummy DUMMY_COLUMN_NUMBER_745
     , dummy DUMMY_COLUMN_NUMBER_746
     , dummy DUMMY_COLUMN_NUMBER_747
     , dummy DUMMY_COLUMN_NUMBER_748
     , dummy DUMMY_COLUMN_NUMBER_749
     , dummy DUMMY_COLUMN_NUMBER_750
     , dummy DUMMY_COLUMN_NUMBER_751
     , dummy DUMMY_COLUMN_NUMBER_752
     , dummy DUMMY_COLUMN_NUMBER_753
     , dummy DUMMY_COLUMN_NUMBER_754
     , dummy DUMMY_COLUMN_NUMBER_755
     , dummy DUMMY_COLUMN_NUMBER_756
     , dummy DUMMY_COLUMN_NUMBER_757
     , dummy DUMMY_COLUMN_NUMBER_758
     , dummy DUMMY_COLUMN_NUMBER_759
     , dummy DUMMY_COLUMN_NUMBER_760
     , dummy DUMMY_COLUMN_NUMBER_761
     , dummy DUMMY_COLUMN_NUMBER_762
     , dummy DUMMY_COLUMN_NUMBER_763
     , dummy DUMMY_COLUMN_NUMBER_764
     , dummy DUMMY_COLUMN_NUMBER_765
     , dummy DUMMY_COLUMN_NUMBER_766
     , dummy DUMMY_COLUMN_NUMBER_767
     , dummy DUMMY_COLUMN_NUMBER_768
     , dummy DUMMY_COLUMN_NUMBER_769
     , dummy DUMMY_COLUMN_NUMBER_770
     , dummy DUMMY_COLUMN_NUMBER_771
     , dummy DUMMY_COLUMN_NUMBER_772
     , dummy DUMMY_COLUMN_NUMBER_773
     , dummy DUMMY_COLUMN_NUMBER_774
     , dummy DUMMY_COLUMN_NUMBER_775
     , dummy DUMMY_COLUMN_NUMBER_776
     , dummy DUMMY_COLUMN_NUMBER_777
     , dummy DUMMY_COLUMN_NUMBER_778
     , dummy DUMMY_COLUMN_NUMBER_779
     , dummy DUMMY_COLUMN_NUMBER_780
     , dummy DUMMY_COLUMN_NUMBER_781
     , dummy DUMMY_COLUMN_NUMBER_782
     , dummy DUMMY_COLUMN_NUMBER_783
     , dummy DUMMY_COLUMN_NUMBER_784
     , dummy DUMMY_COLUMN_NUMBER_785
     , dummy DUMMY_COLUMN_NUMBER_786
     , dummy DUMMY_COLUMN_NUMBER_787
     , dummy DUMMY_COLUMN_NUMBER_788
     , dummy DUMMY_COLUMN_NUMBER_789
     , dummy DUMMY_COLUMN_NUMBER_790
     , dummy DUMMY_COLUMN_NUMBER_791
     , dummy DUMMY_COLUMN_NUMBER_792
     , dummy DUMMY_COLUMN_NUMBER_793
     , dummy DUMMY_COLUMN_NUMBER_794
     , dummy DUMMY_COLUMN_NUMBER_795
     , dummy DUMMY_COLUMN_NUMBER_796
     , dummy DUMMY_COLUMN_NUMBER_797
     , dummy DUMMY_COLUMN_NUMBER_798
     , dummy DUMMY_COLUMN_NUMBER_799
     , dummy DUMMY_COLUMN_NUMBER_800}') || TO_CLOB(q'{
     , dummy DUMMY_COLUMN_NUMBER_801
     , dummy DUMMY_COLUMN_NUMBER_802
     , dummy DUMMY_COLUMN_NUMBER_803
     , dummy DUMMY_COLUMN_NUMBER_804
     , dummy DUMMY_COLUMN_NUMBER_805
     , dummy DUMMY_COLUMN_NUMBER_806
     , dummy DUMMY_COLUMN_NUMBER_807
     , dummy DUMMY_COLUMN_NUMBER_808
     , dummy DUMMY_COLUMN_NUMBER_809
     , dummy DUMMY_COLUMN_NUMBER_810
     , dummy DUMMY_COLUMN_NUMBER_811
     , dummy DUMMY_COLUMN_NUMBER_812
     , dummy DUMMY_COLUMN_NUMBER_813
     , dummy DUMMY_COLUMN_NUMBER_814
     , dummy DUMMY_COLUMN_NUMBER_815
     , dummy DUMMY_COLUMN_NUMBER_816
     , dummy DUMMY_COLUMN_NUMBER_817
     , dummy DUMMY_COLUMN_NUMBER_818
     , dummy DUMMY_COLUMN_NUMBER_819
     , dummy DUMMY_COLUMN_NUMBER_820
     , dummy DUMMY_COLUMN_NUMBER_821
     , dummy DUMMY_COLUMN_NUMBER_822
     , dummy DUMMY_COLUMN_NUMBER_823
     , dummy DUMMY_COLUMN_NUMBER_824
     , dummy DUMMY_COLUMN_NUMBER_825
     , dummy DUMMY_COLUMN_NUMBER_826
     , dummy DUMMY_COLUMN_NUMBER_827
     , dummy DUMMY_COLUMN_NUMBER_828
     , dummy DUMMY_COLUMN_NUMBER_829
     , dummy DUMMY_COLUMN_NUMBER_830
     , dummy DUMMY_COLUMN_NUMBER_831
     , dummy DUMMY_COLUMN_NUMBER_832
     , dummy DUMMY_COLUMN_NUMBER_833
     , dummy DUMMY_COLUMN_NUMBER_834
     , dummy DUMMY_COLUMN_NUMBER_835
     , dummy DUMMY_COLUMN_NUMBER_836
     , dummy DUMMY_COLUMN_NUMBER_837
     , dummy DUMMY_COLUMN_NUMBER_838
     , dummy DUMMY_COLUMN_NUMBER_839
     , dummy DUMMY_COLUMN_NUMBER_840
     , dummy DUMMY_COLUMN_NUMBER_841
     , dummy DUMMY_COLUMN_NUMBER_842
     , dummy DUMMY_COLUMN_NUMBER_843
     , dummy DUMMY_COLUMN_NUMBER_844
     , dummy DUMMY_COLUMN_NUMBER_845
     , dummy DUMMY_COLUMN_NUMBER_846
     , dummy DUMMY_COLUMN_NUMBER_847
     , dummy DUMMY_COLUMN_NUMBER_848
     , dummy DUMMY_COLUMN_NUMBER_849
     , dummy DUMMY_COLUMN_NUMBER_850
     , dummy DUMMY_COLUMN_NUMBER_851
     , dummy DUMMY_COLUMN_NUMBER_852
     , dummy DUMMY_COLUMN_NUMBER_853
     , dummy DUMMY_COLUMN_NUMBER_854
     , dummy DUMMY_COLUMN_NUMBER_855
     , dummy DUMMY_COLUMN_NUMBER_856
     , dummy DUMMY_COLUMN_NUMBER_857
     , dummy DUMMY_COLUMN_NUMBER_858
     , dummy DUMMY_COLUMN_NUMBER_859
     , dummy DUMMY_COLUMN_NUMBER_860
     , dummy DUMMY_COLUMN_NUMBER_861
     , dummy DUMMY_COLUMN_NUMBER_862
     , dummy DUMMY_COLUMN_NUMBER_863
     , dummy DUMMY_COLUMN_NUMBER_864
     , dummy DUMMY_COLUMN_NUMBER_865
     , dummy DUMMY_COLUMN_NUMBER_866
     , dummy DUMMY_COLUMN_NUMBER_867
     , dummy DUMMY_COLUMN_NUMBER_868
     , dummy DUMMY_COLUMN_NUMBER_869
     , dummy DUMMY_COLUMN_NUMBER_870
     , dummy DUMMY_COLUMN_NUMBER_871
     , dummy DUMMY_COLUMN_NUMBER_872
     , dummy DUMMY_COLUMN_NUMBER_873
     , dummy DUMMY_COLUMN_NUMBER_874
     , dummy DUMMY_COLUMN_NUMBER_875
     , dummy DUMMY_COLUMN_NUMBER_876
     , dummy DUMMY_COLUMN_NUMBER_877
     , dummy DUMMY_COLUMN_NUMBER_878
     , dummy DUMMY_COLUMN_NUMBER_879
     , dummy DUMMY_COLUMN_NUMBER_880
     , dummy DUMMY_COLUMN_NUMBER_881
     , dummy DUMMY_COLUMN_NUMBER_882
     , dummy DUMMY_COLUMN_NUMBER_883
     , dummy DUMMY_COLUMN_NUMBER_884
     , dummy DUMMY_COLUMN_NUMBER_885
     , dummy DUMMY_COLUMN_NUMBER_886
     , dummy DUMMY_COLUMN_NUMBER_887
     , dummy DUMMY_COLUMN_NUMBER_888
     , dummy DUMMY_COLUMN_NUMBER_889
     , dummy DUMMY_COLUMN_NUMBER_890
     , dummy DUMMY_COLUMN_NUMBER_891
     , dummy DUMMY_COLUMN_NUMBER_892
     , dummy DUMMY_COLUMN_NUMBER_893
     , dummy DUMMY_COLUMN_NUMBER_894
     , dummy DUMMY_COLUMN_NUMBER_895
     , dummy DUMMY_COLUMN_NUMBER_896
     , dummy DUMMY_COLUMN_NUMBER_897
     , dummy DUMMY_COLUMN_NUMBER_898
     , dummy DUMMY_COLUMN_NUMBER_899
     , dummy DUMMY_COLUMN_NUMBER_900
     , dummy DUMMY_COLUMN_NUMBER_901
     , dummy DUMMY_COLUMN_NUMBER_902
     , dummy DUMMY_COLUMN_NUMBER_903
     , dummy DUMMY_COLUMN_NUMBER_904
     , dummy DUMMY_COLUMN_NUMBER_905
     , dummy DUMMY_COLUMN_NUMBER_906
     , dummy DUMMY_COLUMN_NUMBER_907
     , dummy DUMMY_COLUMN_NUMBER_908
     , dummy DUMMY_COLUMN_NUMBER_909
     , dummy DUMMY_COLUMN_NUMBER_910
     , dummy DUMMY_COLUMN_NUMBER_911
     , dummy DUMMY_COLUMN_NUMBER_912
     , dummy DUMMY_COLUMN_NUMBER_913
     , dummy DUMMY_COLUMN_NUMBER_914
     , dummy DUMMY_COLUMN_NUMBER_915
     , dummy DUMMY_COLUMN_NUMBER_916
     , dummy DUMMY_COLUMN_NUMBER_917
     , dummy DUMMY_COLUMN_NUMBER_918
     , dummy DUMMY_COLUMN_NUMBER_919
     , dummy DUMMY_COLUMN_NUMBER_920
     , dummy DUMMY_COLUMN_NUMBER_921
     , dummy DUMMY_COLUMN_NUMBER_922
     , dummy DUMMY_COLUMN_NUMBER_923
     , dummy DUMMY_COLUMN_NUMBER_924
     , dummy DUMMY_COLUMN_NUMBER_925
     , dummy DUMMY_COLUMN_NUMBER_926
     , dummy DUMMY_COLUMN_NUMBER_927
     , dummy DUMMY_COLUMN_NUMBER_928
     , dummy DUMMY_COLUMN_NUMBER_929
     , dummy DUMMY_COLUMN_NUMBER_930
     , dummy DUMMY_COLUMN_NUMBER_931
     , dummy DUMMY_COLUMN_NUMBER_932
     , dummy DUMMY_COLUMN_NUMBER_933
     , dummy DUMMY_COLUMN_NUMBER_934
     , dummy DUMMY_COLUMN_NUMBER_935
     , dummy DUMMY_COLUMN_NUMBER_936
     , dummy DUMMY_COLUMN_NUMBER_937
     , dummy DUMMY_COLUMN_NUMBER_938
     , dummy DUMMY_COLUMN_NUMBER_939
     , dummy DUMMY_COLUMN_NUMBER_940
     , dummy DUMMY_COLUMN_NUMBER_941
     , dummy DUMMY_COLUMN_NUMBER_942
     , dummy DUMMY_COLUMN_NUMBER_943
     , dummy DUMMY_COLUMN_NUMBER_944
     , dummy DUMMY_COLUMN_NUMBER_945
     , dummy DUMMY_COLUMN_NUMBER_946
     , dummy DUMMY_COLUMN_NUMBER_947
     , dummy DUMMY_COLUMN_NUMBER_948
     , dummy DUMMY_COLUMN_NUMBER_949
     , dummy DUMMY_COLUMN_NUMBER_950
     , dummy DUMMY_COLUMN_NUMBER_951
     , dummy DUMMY_COLUMN_NUMBER_952
     , dummy DUMMY_COLUMN_NUMBER_953
     , dummy DUMMY_COLUMN_NUMBER_954
     , dummy DUMMY_COLUMN_NUMBER_955
     , dummy DUMMY_COLUMN_NUMBER_956
     , dummy DUMMY_COLUMN_NUMBER_957
     , dummy DUMMY_COLUMN_NUMBER_958
     , dummy DUMMY_COLUMN_NUMBER_959
     , dummy DUMMY_COLUMN_NUMBER_960
     , dummy DUMMY_COLUMN_NUMBER_961
     , dummy DUMMY_COLUMN_NUMBER_962
     , dummy DUMMY_COLUMN_NUMBER_963
     , dummy DUMMY_COLUMN_NUMBER_964
     , dummy DUMMY_COLUMN_NUMBER_965
     , dummy DUMMY_COLUMN_NUMBER_966
     , dummy DUMMY_COLUMN_NUMBER_967
     , dummy DUMMY_COLUMN_NUMBER_968
     , dummy DUMMY_COLUMN_NUMBER_969
     , dummy DUMMY_COLUMN_NUMBER_970
     , dummy DUMMY_COLUMN_NUMBER_971
     , dummy DUMMY_COLUMN_NUMBER_972
     , dummy DUMMY_COLUMN_NUMBER_973
     , dummy DUMMY_COLUMN_NUMBER_974
     , dummy DUMMY_COLUMN_NUMBER_975
     , dummy DUMMY_COLUMN_NUMBER_976
     , dummy DUMMY_COLUMN_NUMBER_977
     , dummy DUMMY_COLUMN_NUMBER_978
     , dummy DUMMY_COLUMN_NUMBER_979
     , dummy DUMMY_COLUMN_NUMBER_980
     , dummy DUMMY_COLUMN_NUMBER_981
     , dummy DUMMY_COLUMN_NUMBER_982
     , dummy DUMMY_COLUMN_NUMBER_983
     , dummy DUMMY_COLUMN_NUMBER_984
     , dummy DUMMY_COLUMN_NUMBER_985
     , dummy DUMMY_COLUMN_NUMBER_986
     , dummy DUMMY_COLUMN_NUMBER_987
     , dummy DUMMY_COLUMN_NUMBER_988
     , dummy DUMMY_COLUMN_NUMBER_989
     , dummy DUMMY_COLUMN_NUMBER_990
     , dummy DUMMY_COLUMN_NUMBER_991
     , dummy DUMMY_COLUMN_NUMBER_992
     , dummy DUMMY_COLUMN_NUMBER_993
     , dummy DUMMY_COLUMN_NUMBER_994
     , dummy DUMMY_COLUMN_NUMBER_995
     , dummy DUMMY_COLUMN_NUMBER_996
     , dummy DUMMY_COLUMN_NUMBER_997
     , dummy DUMMY_COLUMN_NUMBER_998
     , dummy DUMMY_COLUMN_NUMBER_999
     , dummy DUMMY_COLUMN_NUMBER_1000
     , dummy DUMMY_COLUMN_NUMBER_1001
     , dummy DUMMY_COLUMN_NUMBER_1002
     , dummy DUMMY_COLUMN_NUMBER_1003
     , dummy DUMMY_COLUMN_NUMBER_1004
     , dummy DUMMY_COLUMN_NUMBER_1005
     , dummy DUMMY_COLUMN_NUMBER_1006
     , dummy DUMMY_COLUMN_NUMBER_1007
     , dummy DUMMY_COLUMN_NUMBER_1008
     , dummy DUMMY_COLUMN_NUMBER_1009
     , dummy DUMMY_COLUMN_NUMBER_1010
     , dummy DUMMY_COLUMN_NUMBER_1011
     , dummy DUMMY_COLUMN_NUMBER_1012
     , dummy DUMMY_COLUMN_NUMBER_1013
     , dummy DUMMY_COLUMN_NUMBER_1014
     , dummy DUMMY_COLUMN_NUMBER_1015
     , dummy DUMMY_COLUMN_NUMBER_1016
     , dummy DUMMY_COLUMN_NUMBER_1017
     , dummy DUMMY_COLUMN_NUMBER_1018
     , dummy DUMMY_COLUMN_NUMBER_1019
     , dummy DUMMY_COLUMN_NUMBER_1020
     , dummy DUMMY_COLUMN_NUMBER_1021
     , dummy DUMMY_COLUMN_NUMBER_1022
     , dummy DUMMY_COLUMN_NUMBER_1023
     , dummy DUMMY_COLUMN_NUMBER_1024
from dual }');
       
    dbms_utility.expand_sql_text(
        input_sql_text => v_input
      , output_sql_text => v_output
    );
  
    dbms_output.put_line(v_output);
  
  $end
end;
/

ORA-06502: PL/SQL: numeric or value error with DBMS_UTILITY.EXPAND_SQL_TEXT

If you encounter ORA-06502, you may be trying to print a query that is too long to your DBMS_OUTPUT. DBMS_OUTPUT has a max of 32,767 characters per line. As a result, you might want to include a little extra code at the bottom that breaks up your code. By printing the SQL a small chunk at a time, you can prevent this error.

set serveroutput on;

declare
  v_input clob;
  v_output clob;
  v_firstloop boolean := true;
begin
  $if dbms_db_version.ver_le_9
      or dbms_db_version.ver_le_10 
      or dbms_db_version.ver_le_11 
  $then
    dbms_output.put_line('DBMS_UTILITY.EXPAND_SQL_TEXT requires Oracle 12c or above!');
  $else
    v_input := to_clob(q'{ 
       select dummy DUMMY_COLUMN_NUMBER_0
     , dummy DUMMY_COLUMN_NUMBER_1
     , dummy DUMMY_COLUMN_NUMBER_2
     , dummy DUMMY_COLUMN_NUMBER_3
     , dummy DUMMY_COLUMN_NUMBER_4
     , dummy DUMMY_COLUMN_NUMBER_5
     , dummy DUMMY_COLUMN_NUMBER_6
     , dummy DUMMY_COLUMN_NUMBER_7
     , dummy DUMMY_COLUMN_NUMBER_8
     , dummy DUMMY_COLUMN_NUMBER_9
     , dummy DUMMY_COLUMN_NUMBER_10
     , dummy DUMMY_COLUMN_NUMBER_11
     , dummy DUMMY_COLUMN_NUMBER_12
     , dummy DUMMY_COLUMN_NUMBER_13
     , dummy DUMMY_COLUMN_NUMBER_14
     , dummy DUMMY_COLUMN_NUMBER_15
     , dummy DUMMY_COLUMN_NUMBER_16
     , dummy DUMMY_COLUMN_NUMBER_17
     , dummy DUMMY_COLUMN_NUMBER_18
     , dummy DUMMY_COLUMN_NUMBER_19
     , dummy DUMMY_COLUMN_NUMBER_20
     , dummy DUMMY_COLUMN_NUMBER_21
     , dummy DUMMY_COLUMN_NUMBER_22
     , dummy DUMMY_COLUMN_NUMBER_23
     , dummy DUMMY_COLUMN_NUMBER_24
     , dummy DUMMY_COLUMN_NUMBER_25
     , dummy DUMMY_COLUMN_NUMBER_26
     , dummy DUMMY_COLUMN_NUMBER_27
     , dummy DUMMY_COLUMN_NUMBER_28
     , dummy DUMMY_COLUMN_NUMBER_29
     , dummy DUMMY_COLUMN_NUMBER_30
     , dummy DUMMY_COLUMN_NUMBER_31
     , dummy DUMMY_COLUMN_NUMBER_32
     , dummy DUMMY_COLUMN_NUMBER_33
     , dummy DUMMY_COLUMN_NUMBER_34
     , dummy DUMMY_COLUMN_NUMBER_35
     , dummy DUMMY_COLUMN_NUMBER_36
     , dummy DUMMY_COLUMN_NUMBER_37
     , dummy DUMMY_COLUMN_NUMBER_38
     , dummy DUMMY_COLUMN_NUMBER_39
     , dummy DUMMY_COLUMN_NUMBER_40
     , dummy DUMMY_COLUMN_NUMBER_41
     , dummy DUMMY_COLUMN_NUMBER_42
     , dummy DUMMY_COLUMN_NUMBER_43
     , dummy DUMMY_COLUMN_NUMBER_44
     , dummy DUMMY_COLUMN_NUMBER_45
     , dummy DUMMY_COLUMN_NUMBER_46
     , dummy DUMMY_COLUMN_NUMBER_47
     , dummy DUMMY_COLUMN_NUMBER_48
     , dummy DUMMY_COLUMN_NUMBER_49
     , dummy DUMMY_COLUMN_NUMBER_50
     , dummy DUMMY_COLUMN_NUMBER_51
     , dummy DUMMY_COLUMN_NUMBER_52
     , dummy DUMMY_COLUMN_NUMBER_53
     , dummy DUMMY_COLUMN_NUMBER_54
     , dummy DUMMY_COLUMN_NUMBER_55
     , dummy DUMMY_COLUMN_NUMBER_56
     , dummy DUMMY_COLUMN_NUMBER_57
     , dummy DUMMY_COLUMN_NUMBER_58
     , dummy DUMMY_COLUMN_NUMBER_59
     , dummy DUMMY_COLUMN_NUMBER_60
     , dummy DUMMY_COLUMN_NUMBER_61
     , dummy DUMMY_COLUMN_NUMBER_62
     , dummy DUMMY_COLUMN_NUMBER_63
     , dummy DUMMY_COLUMN_NUMBER_64
     , dummy DUMMY_COLUMN_NUMBER_65
     , dummy DUMMY_COLUMN_NUMBER_66
     , dummy DUMMY_COLUMN_NUMBER_67
     , dummy DUMMY_COLUMN_NUMBER_68
     , dummy DUMMY_COLUMN_NUMBER_69
     , dummy DUMMY_COLUMN_NUMBER_70
     , dummy DUMMY_COLUMN_NUMBER_71
     , dummy DUMMY_COLUMN_NUMBER_72
     , dummy DUMMY_COLUMN_NUMBER_73
     , dummy DUMMY_COLUMN_NUMBER_74
     , dummy DUMMY_COLUMN_NUMBER_75
     , dummy DUMMY_COLUMN_NUMBER_76
     , dummy DUMMY_COLUMN_NUMBER_77
     , dummy DUMMY_COLUMN_NUMBER_78
     , dummy DUMMY_COLUMN_NUMBER_79
     , dummy DUMMY_COLUMN_NUMBER_80
     , dummy DUMMY_COLUMN_NUMBER_81
     , dummy DUMMY_COLUMN_NUMBER_82
     , dummy DUMMY_COLUMN_NUMBER_83
     , dummy DUMMY_COLUMN_NUMBER_84
     , dummy DUMMY_COLUMN_NUMBER_85
     , dummy DUMMY_COLUMN_NUMBER_86
     , dummy DUMMY_COLUMN_NUMBER_87
     , dummy DUMMY_COLUMN_NUMBER_88
     , dummy DUMMY_COLUMN_NUMBER_89
     , dummy DUMMY_COLUMN_NUMBER_90
     , dummy DUMMY_COLUMN_NUMBER_91
     , dummy DUMMY_COLUMN_NUMBER_92
     , dummy DUMMY_COLUMN_NUMBER_93
     , dummy DUMMY_COLUMN_NUMBER_94
     , dummy DUMMY_COLUMN_NUMBER_95
     , dummy DUMMY_COLUMN_NUMBER_96
     , dummy DUMMY_COLUMN_NUMBER_97
     , dummy DUMMY_COLUMN_NUMBER_98
     , dummy DUMMY_COLUMN_NUMBER_99
     , dummy DUMMY_COLUMN_NUMBER_100
     , dummy DUMMY_COLUMN_NUMBER_101
     , dummy DUMMY_COLUMN_NUMBER_102
     , dummy DUMMY_COLUMN_NUMBER_103
     , dummy DUMMY_COLUMN_NUMBER_104
     , dummy DUMMY_COLUMN_NUMBER_105
     , dummy DUMMY_COLUMN_NUMBER_106
     , dummy DUMMY_COLUMN_NUMBER_107
     , dummy DUMMY_COLUMN_NUMBER_108
     , dummy DUMMY_COLUMN_NUMBER_109
     , dummy DUMMY_COLUMN_NUMBER_110
     , dummy DUMMY_COLUMN_NUMBER_111
     , dummy DUMMY_COLUMN_NUMBER_112
     , dummy DUMMY_COLUMN_NUMBER_113
     , dummy DUMMY_COLUMN_NUMBER_114
     , dummy DUMMY_COLUMN_NUMBER_115
     , dummy DUMMY_COLUMN_NUMBER_116
     , dummy DUMMY_COLUMN_NUMBER_117
     , dummy DUMMY_COLUMN_NUMBER_118
     , dummy DUMMY_COLUMN_NUMBER_119
     , dummy DUMMY_COLUMN_NUMBER_120
     , dummy DUMMY_COLUMN_NUMBER_121
     , dummy DUMMY_COLUMN_NUMBER_122
     , dummy DUMMY_COLUMN_NUMBER_123
     , dummy DUMMY_COLUMN_NUMBER_124
     , dummy DUMMY_COLUMN_NUMBER_125
     , dummy DUMMY_COLUMN_NUMBER_126
     , dummy DUMMY_COLUMN_NUMBER_127
     , dummy DUMMY_COLUMN_NUMBER_128
     , dummy DUMMY_COLUMN_NUMBER_129
     , dummy DUMMY_COLUMN_NUMBER_130
     , dummy DUMMY_COLUMN_NUMBER_131
     , dummy DUMMY_COLUMN_NUMBER_132
     , dummy DUMMY_COLUMN_NUMBER_133
     , dummy DUMMY_COLUMN_NUMBER_134
     , dummy DUMMY_COLUMN_NUMBER_135
     , dummy DUMMY_COLUMN_NUMBER_136
     , dummy DUMMY_COLUMN_NUMBER_137
     , dummy DUMMY_COLUMN_NUMBER_138
     , dummy DUMMY_COLUMN_NUMBER_139
     , dummy DUMMY_COLUMN_NUMBER_140
     , dummy DUMMY_COLUMN_NUMBER_141
     , dummy DUMMY_COLUMN_NUMBER_142
     , dummy DUMMY_COLUMN_NUMBER_143
     , dummy DUMMY_COLUMN_NUMBER_144
     , dummy DUMMY_COLUMN_NUMBER_145
     , dummy DUMMY_COLUMN_NUMBER_146
     , dummy DUMMY_COLUMN_NUMBER_147
     , dummy DUMMY_COLUMN_NUMBER_148
     , dummy DUMMY_COLUMN_NUMBER_149
     , dummy DUMMY_COLUMN_NUMBER_150
     , dummy DUMMY_COLUMN_NUMBER_151
     , dummy DUMMY_COLUMN_NUMBER_152
     , dummy DUMMY_COLUMN_NUMBER_153
     , dummy DUMMY_COLUMN_NUMBER_154
     , dummy DUMMY_COLUMN_NUMBER_155
     , dummy DUMMY_COLUMN_NUMBER_156
     , dummy DUMMY_COLUMN_NUMBER_157
     , dummy DUMMY_COLUMN_NUMBER_158
     , dummy DUMMY_COLUMN_NUMBER_159
     , dummy DUMMY_COLUMN_NUMBER_160
     , dummy DUMMY_COLUMN_NUMBER_161
     , dummy DUMMY_COLUMN_NUMBER_162
     , dummy DUMMY_COLUMN_NUMBER_163
     , dummy DUMMY_COLUMN_NUMBER_164
     , dummy DUMMY_COLUMN_NUMBER_165
     , dummy DUMMY_COLUMN_NUMBER_166
     , dummy DUMMY_COLUMN_NUMBER_167
     , dummy DUMMY_COLUMN_NUMBER_168
     , dummy DUMMY_COLUMN_NUMBER_169
     , dummy DUMMY_COLUMN_NUMBER_170
     , dummy DUMMY_COLUMN_NUMBER_171
     , dummy DUMMY_COLUMN_NUMBER_172
     , dummy DUMMY_COLUMN_NUMBER_173
     , dummy DUMMY_COLUMN_NUMBER_174
     , dummy DUMMY_COLUMN_NUMBER_175
     , dummy DUMMY_COLUMN_NUMBER_176
     , dummy DUMMY_COLUMN_NUMBER_177
     , dummy DUMMY_COLUMN_NUMBER_178
     , dummy DUMMY_COLUMN_NUMBER_179
     , dummy DUMMY_COLUMN_NUMBER_180
     , dummy DUMMY_COLUMN_NUMBER_181
     , dummy DUMMY_COLUMN_NUMBER_182
     , dummy DUMMY_COLUMN_NUMBER_183
     , dummy DUMMY_COLUMN_NUMBER_184
     , dummy DUMMY_COLUMN_NUMBER_185
     , dummy DUMMY_COLUMN_NUMBER_186
     , dummy DUMMY_COLUMN_NUMBER_187
     , dummy DUMMY_COLUMN_NUMBER_188
     , dummy DUMMY_COLUMN_NUMBER_189
     , dummy DUMMY_COLUMN_NUMBER_190
     , dummy DUMMY_COLUMN_NUMBER_191
     , dummy DUMMY_COLUMN_NUMBER_192
     , dummy DUMMY_COLUMN_NUMBER_193
     , dummy DUMMY_COLUMN_NUMBER_194
     , dummy DUMMY_COLUMN_NUMBER_195
     , dummy DUMMY_COLUMN_NUMBER_196
     , dummy DUMMY_COLUMN_NUMBER_197
     , dummy DUMMY_COLUMN_NUMBER_198
     , dummy DUMMY_COLUMN_NUMBER_199
     , dummy DUMMY_COLUMN_NUMBER_200}') || TO_CLOB(q'{
     , dummy DUMMY_COLUMN_NUMBER_201
     , dummy DUMMY_COLUMN_NUMBER_202
     , dummy DUMMY_COLUMN_NUMBER_203
     , dummy DUMMY_COLUMN_NUMBER_204
     , dummy DUMMY_COLUMN_NUMBER_205
     , dummy DUMMY_COLUMN_NUMBER_206
     , dummy DUMMY_COLUMN_NUMBER_207
     , dummy DUMMY_COLUMN_NUMBER_208
     , dummy DUMMY_COLUMN_NUMBER_209
     , dummy DUMMY_COLUMN_NUMBER_210
     , dummy DUMMY_COLUMN_NUMBER_211
     , dummy DUMMY_COLUMN_NUMBER_212
     , dummy DUMMY_COLUMN_NUMBER_213
     , dummy DUMMY_COLUMN_NUMBER_214
     , dummy DUMMY_COLUMN_NUMBER_215
     , dummy DUMMY_COLUMN_NUMBER_216
     , dummy DUMMY_COLUMN_NUMBER_217
     , dummy DUMMY_COLUMN_NUMBER_218
     , dummy DUMMY_COLUMN_NUMBER_219
     , dummy DUMMY_COLUMN_NUMBER_220
     , dummy DUMMY_COLUMN_NUMBER_221
     , dummy DUMMY_COLUMN_NUMBER_222
     , dummy DUMMY_COLUMN_NUMBER_223
     , dummy DUMMY_COLUMN_NUMBER_224
     , dummy DUMMY_COLUMN_NUMBER_225
     , dummy DUMMY_COLUMN_NUMBER_226
     , dummy DUMMY_COLUMN_NUMBER_227
     , dummy DUMMY_COLUMN_NUMBER_228
     , dummy DUMMY_COLUMN_NUMBER_229
     , dummy DUMMY_COLUMN_NUMBER_230
     , dummy DUMMY_COLUMN_NUMBER_231
     , dummy DUMMY_COLUMN_NUMBER_232
     , dummy DUMMY_COLUMN_NUMBER_233
     , dummy DUMMY_COLUMN_NUMBER_234
     , dummy DUMMY_COLUMN_NUMBER_235
     , dummy DUMMY_COLUMN_NUMBER_236
     , dummy DUMMY_COLUMN_NUMBER_237
     , dummy DUMMY_COLUMN_NUMBER_238
     , dummy DUMMY_COLUMN_NUMBER_239
     , dummy DUMMY_COLUMN_NUMBER_240
     , dummy DUMMY_COLUMN_NUMBER_241
     , dummy DUMMY_COLUMN_NUMBER_242
     , dummy DUMMY_COLUMN_NUMBER_243
     , dummy DUMMY_COLUMN_NUMBER_244
     , dummy DUMMY_COLUMN_NUMBER_245
     , dummy DUMMY_COLUMN_NUMBER_246
     , dummy DUMMY_COLUMN_NUMBER_247
     , dummy DUMMY_COLUMN_NUMBER_248
     , dummy DUMMY_COLUMN_NUMBER_249
     , dummy DUMMY_COLUMN_NUMBER_250
     , dummy DUMMY_COLUMN_NUMBER_251
     , dummy DUMMY_COLUMN_NUMBER_252
     , dummy DUMMY_COLUMN_NUMBER_253
     , dummy DUMMY_COLUMN_NUMBER_254
     , dummy DUMMY_COLUMN_NUMBER_255
     , dummy DUMMY_COLUMN_NUMBER_256
     , dummy DUMMY_COLUMN_NUMBER_257
     , dummy DUMMY_COLUMN_NUMBER_258
     , dummy DUMMY_COLUMN_NUMBER_259
     , dummy DUMMY_COLUMN_NUMBER_260
     , dummy DUMMY_COLUMN_NUMBER_261
     , dummy DUMMY_COLUMN_NUMBER_262
     , dummy DUMMY_COLUMN_NUMBER_263
     , dummy DUMMY_COLUMN_NUMBER_264
     , dummy DUMMY_COLUMN_NUMBER_265
     , dummy DUMMY_COLUMN_NUMBER_266
     , dummy DUMMY_COLUMN_NUMBER_267
     , dummy DUMMY_COLUMN_NUMBER_268
     , dummy DUMMY_COLUMN_NUMBER_269
     , dummy DUMMY_COLUMN_NUMBER_270
     , dummy DUMMY_COLUMN_NUMBER_271
     , dummy DUMMY_COLUMN_NUMBER_272
     , dummy DUMMY_COLUMN_NUMBER_273
     , dummy DUMMY_COLUMN_NUMBER_274
     , dummy DUMMY_COLUMN_NUMBER_275
     , dummy DUMMY_COLUMN_NUMBER_276
     , dummy DUMMY_COLUMN_NUMBER_277
     , dummy DUMMY_COLUMN_NUMBER_278
     , dummy DUMMY_COLUMN_NUMBER_279
     , dummy DUMMY_COLUMN_NUMBER_280
     , dummy DUMMY_COLUMN_NUMBER_281
     , dummy DUMMY_COLUMN_NUMBER_282
     , dummy DUMMY_COLUMN_NUMBER_283
     , dummy DUMMY_COLUMN_NUMBER_284
     , dummy DUMMY_COLUMN_NUMBER_285
     , dummy DUMMY_COLUMN_NUMBER_286
     , dummy DUMMY_COLUMN_NUMBER_287
     , dummy DUMMY_COLUMN_NUMBER_288
     , dummy DUMMY_COLUMN_NUMBER_289
     , dummy DUMMY_COLUMN_NUMBER_290
     , dummy DUMMY_COLUMN_NUMBER_291
     , dummy DUMMY_COLUMN_NUMBER_292
     , dummy DUMMY_COLUMN_NUMBER_293
     , dummy DUMMY_COLUMN_NUMBER_294
     , dummy DUMMY_COLUMN_NUMBER_295
     , dummy DUMMY_COLUMN_NUMBER_296
     , dummy DUMMY_COLUMN_NUMBER_297
     , dummy DUMMY_COLUMN_NUMBER_298
     , dummy DUMMY_COLUMN_NUMBER_299
     , dummy DUMMY_COLUMN_NUMBER_300
     , dummy DUMMY_COLUMN_NUMBER_301
     , dummy DUMMY_COLUMN_NUMBER_302
     , dummy DUMMY_COLUMN_NUMBER_303
     , dummy DUMMY_COLUMN_NUMBER_304
     , dummy DUMMY_COLUMN_NUMBER_305
     , dummy DUMMY_COLUMN_NUMBER_306
     , dummy DUMMY_COLUMN_NUMBER_307
     , dummy DUMMY_COLUMN_NUMBER_308
     , dummy DUMMY_COLUMN_NUMBER_309
     , dummy DUMMY_COLUMN_NUMBER_310
     , dummy DUMMY_COLUMN_NUMBER_311
     , dummy DUMMY_COLUMN_NUMBER_312
     , dummy DUMMY_COLUMN_NUMBER_313
     , dummy DUMMY_COLUMN_NUMBER_314
     , dummy DUMMY_COLUMN_NUMBER_315
     , dummy DUMMY_COLUMN_NUMBER_316
     , dummy DUMMY_COLUMN_NUMBER_317
     , dummy DUMMY_COLUMN_NUMBER_318
     , dummy DUMMY_COLUMN_NUMBER_319
     , dummy DUMMY_COLUMN_NUMBER_320
     , dummy DUMMY_COLUMN_NUMBER_321
     , dummy DUMMY_COLUMN_NUMBER_322
     , dummy DUMMY_COLUMN_NUMBER_323
     , dummy DUMMY_COLUMN_NUMBER_324
     , dummy DUMMY_COLUMN_NUMBER_325
     , dummy DUMMY_COLUMN_NUMBER_326
     , dummy DUMMY_COLUMN_NUMBER_327
     , dummy DUMMY_COLUMN_NUMBER_328
     , dummy DUMMY_COLUMN_NUMBER_329
     , dummy DUMMY_COLUMN_NUMBER_330
     , dummy DUMMY_COLUMN_NUMBER_331
     , dummy DUMMY_COLUMN_NUMBER_332
     , dummy DUMMY_COLUMN_NUMBER_333
     , dummy DUMMY_COLUMN_NUMBER_334
     , dummy DUMMY_COLUMN_NUMBER_335
     , dummy DUMMY_COLUMN_NUMBER_336
     , dummy DUMMY_COLUMN_NUMBER_337
     , dummy DUMMY_COLUMN_NUMBER_338
     , dummy DUMMY_COLUMN_NUMBER_339
     , dummy DUMMY_COLUMN_NUMBER_340
     , dummy DUMMY_COLUMN_NUMBER_341
     , dummy DUMMY_COLUMN_NUMBER_342
     , dummy DUMMY_COLUMN_NUMBER_343
     , dummy DUMMY_COLUMN_NUMBER_344
     , dummy DUMMY_COLUMN_NUMBER_345
     , dummy DUMMY_COLUMN_NUMBER_346
     , dummy DUMMY_COLUMN_NUMBER_347
     , dummy DUMMY_COLUMN_NUMBER_348
     , dummy DUMMY_COLUMN_NUMBER_349
     , dummy DUMMY_COLUMN_NUMBER_350
     , dummy DUMMY_COLUMN_NUMBER_351
     , dummy DUMMY_COLUMN_NUMBER_352
     , dummy DUMMY_COLUMN_NUMBER_353
     , dummy DUMMY_COLUMN_NUMBER_354
     , dummy DUMMY_COLUMN_NUMBER_355
     , dummy DUMMY_COLUMN_NUMBER_356
     , dummy DUMMY_COLUMN_NUMBER_357
     , dummy DUMMY_COLUMN_NUMBER_358
     , dummy DUMMY_COLUMN_NUMBER_359
     , dummy DUMMY_COLUMN_NUMBER_360
     , dummy DUMMY_COLUMN_NUMBER_361
     , dummy DUMMY_COLUMN_NUMBER_362
     , dummy DUMMY_COLUMN_NUMBER_363
     , dummy DUMMY_COLUMN_NUMBER_364
     , dummy DUMMY_COLUMN_NUMBER_365
     , dummy DUMMY_COLUMN_NUMBER_366
     , dummy DUMMY_COLUMN_NUMBER_367
     , dummy DUMMY_COLUMN_NUMBER_368
     , dummy DUMMY_COLUMN_NUMBER_369
     , dummy DUMMY_COLUMN_NUMBER_370
     , dummy DUMMY_COLUMN_NUMBER_371
     , dummy DUMMY_COLUMN_NUMBER_372
     , dummy DUMMY_COLUMN_NUMBER_373
     , dummy DUMMY_COLUMN_NUMBER_374
     , dummy DUMMY_COLUMN_NUMBER_375
     , dummy DUMMY_COLUMN_NUMBER_376
     , dummy DUMMY_COLUMN_NUMBER_377
     , dummy DUMMY_COLUMN_NUMBER_378
     , dummy DUMMY_COLUMN_NUMBER_379
     , dummy DUMMY_COLUMN_NUMBER_380
     , dummy DUMMY_COLUMN_NUMBER_381
     , dummy DUMMY_COLUMN_NUMBER_382
     , dummy DUMMY_COLUMN_NUMBER_383
     , dummy DUMMY_COLUMN_NUMBER_384
     , dummy DUMMY_COLUMN_NUMBER_385
     , dummy DUMMY_COLUMN_NUMBER_386
     , dummy DUMMY_COLUMN_NUMBER_387
     , dummy DUMMY_COLUMN_NUMBER_388
     , dummy DUMMY_COLUMN_NUMBER_389
     , dummy DUMMY_COLUMN_NUMBER_390
     , dummy DUMMY_COLUMN_NUMBER_391
     , dummy DUMMY_COLUMN_NUMBER_392
     , dummy DUMMY_COLUMN_NUMBER_393
     , dummy DUMMY_COLUMN_NUMBER_394
     , dummy DUMMY_COLUMN_NUMBER_395
     , dummy DUMMY_COLUMN_NUMBER_396
     , dummy DUMMY_COLUMN_NUMBER_397
     , dummy DUMMY_COLUMN_NUMBER_398
     , dummy DUMMY_COLUMN_NUMBER_399
     , dummy DUMMY_COLUMN_NUMBER_400}') || TO_CLOB(q'{
     , dummy DUMMY_COLUMN_NUMBER_401
     , dummy DUMMY_COLUMN_NUMBER_402
     , dummy DUMMY_COLUMN_NUMBER_403
     , dummy DUMMY_COLUMN_NUMBER_404
     , dummy DUMMY_COLUMN_NUMBER_405
     , dummy DUMMY_COLUMN_NUMBER_406
     , dummy DUMMY_COLUMN_NUMBER_407
     , dummy DUMMY_COLUMN_NUMBER_408
     , dummy DUMMY_COLUMN_NUMBER_409
     , dummy DUMMY_COLUMN_NUMBER_410
     , dummy DUMMY_COLUMN_NUMBER_411
     , dummy DUMMY_COLUMN_NUMBER_412
     , dummy DUMMY_COLUMN_NUMBER_413
     , dummy DUMMY_COLUMN_NUMBER_414
     , dummy DUMMY_COLUMN_NUMBER_415
     , dummy DUMMY_COLUMN_NUMBER_416
     , dummy DUMMY_COLUMN_NUMBER_417
     , dummy DUMMY_COLUMN_NUMBER_418
     , dummy DUMMY_COLUMN_NUMBER_419
     , dummy DUMMY_COLUMN_NUMBER_420
     , dummy DUMMY_COLUMN_NUMBER_421
     , dummy DUMMY_COLUMN_NUMBER_422
     , dummy DUMMY_COLUMN_NUMBER_423
     , dummy DUMMY_COLUMN_NUMBER_424
     , dummy DUMMY_COLUMN_NUMBER_425
     , dummy DUMMY_COLUMN_NUMBER_426
     , dummy DUMMY_COLUMN_NUMBER_427
     , dummy DUMMY_COLUMN_NUMBER_428
     , dummy DUMMY_COLUMN_NUMBER_429
     , dummy DUMMY_COLUMN_NUMBER_430
     , dummy DUMMY_COLUMN_NUMBER_431
     , dummy DUMMY_COLUMN_NUMBER_432
     , dummy DUMMY_COLUMN_NUMBER_433
     , dummy DUMMY_COLUMN_NUMBER_434
     , dummy DUMMY_COLUMN_NUMBER_435
     , dummy DUMMY_COLUMN_NUMBER_436
     , dummy DUMMY_COLUMN_NUMBER_437
     , dummy DUMMY_COLUMN_NUMBER_438
     , dummy DUMMY_COLUMN_NUMBER_439
     , dummy DUMMY_COLUMN_NUMBER_440
     , dummy DUMMY_COLUMN_NUMBER_441
     , dummy DUMMY_COLUMN_NUMBER_442
     , dummy DUMMY_COLUMN_NUMBER_443
     , dummy DUMMY_COLUMN_NUMBER_444
     , dummy DUMMY_COLUMN_NUMBER_445
     , dummy DUMMY_COLUMN_NUMBER_446
     , dummy DUMMY_COLUMN_NUMBER_447
     , dummy DUMMY_COLUMN_NUMBER_448
     , dummy DUMMY_COLUMN_NUMBER_449
     , dummy DUMMY_COLUMN_NUMBER_450
     , dummy DUMMY_COLUMN_NUMBER_451
     , dummy DUMMY_COLUMN_NUMBER_452
     , dummy DUMMY_COLUMN_NUMBER_453
     , dummy DUMMY_COLUMN_NUMBER_454
     , dummy DUMMY_COLUMN_NUMBER_455
     , dummy DUMMY_COLUMN_NUMBER_456
     , dummy DUMMY_COLUMN_NUMBER_457
     , dummy DUMMY_COLUMN_NUMBER_458
     , dummy DUMMY_COLUMN_NUMBER_459
     , dummy DUMMY_COLUMN_NUMBER_460
     , dummy DUMMY_COLUMN_NUMBER_461
     , dummy DUMMY_COLUMN_NUMBER_462
     , dummy DUMMY_COLUMN_NUMBER_463
     , dummy DUMMY_COLUMN_NUMBER_464
     , dummy DUMMY_COLUMN_NUMBER_465
     , dummy DUMMY_COLUMN_NUMBER_466
     , dummy DUMMY_COLUMN_NUMBER_467
     , dummy DUMMY_COLUMN_NUMBER_468
     , dummy DUMMY_COLUMN_NUMBER_469
     , dummy DUMMY_COLUMN_NUMBER_470
     , dummy DUMMY_COLUMN_NUMBER_471
     , dummy DUMMY_COLUMN_NUMBER_472
     , dummy DUMMY_COLUMN_NUMBER_473
     , dummy DUMMY_COLUMN_NUMBER_474
     , dummy DUMMY_COLUMN_NUMBER_475
     , dummy DUMMY_COLUMN_NUMBER_476
     , dummy DUMMY_COLUMN_NUMBER_477
     , dummy DUMMY_COLUMN_NUMBER_478
     , dummy DUMMY_COLUMN_NUMBER_479
     , dummy DUMMY_COLUMN_NUMBER_480
     , dummy DUMMY_COLUMN_NUMBER_481
     , dummy DUMMY_COLUMN_NUMBER_482
     , dummy DUMMY_COLUMN_NUMBER_483
     , dummy DUMMY_COLUMN_NUMBER_484
     , dummy DUMMY_COLUMN_NUMBER_485
     , dummy DUMMY_COLUMN_NUMBER_486
     , dummy DUMMY_COLUMN_NUMBER_487
     , dummy DUMMY_COLUMN_NUMBER_488
     , dummy DUMMY_COLUMN_NUMBER_489
     , dummy DUMMY_COLUMN_NUMBER_490
     , dummy DUMMY_COLUMN_NUMBER_491
     , dummy DUMMY_COLUMN_NUMBER_492
     , dummy DUMMY_COLUMN_NUMBER_493
     , dummy DUMMY_COLUMN_NUMBER_494
     , dummy DUMMY_COLUMN_NUMBER_495
     , dummy DUMMY_COLUMN_NUMBER_496
     , dummy DUMMY_COLUMN_NUMBER_497
     , dummy DUMMY_COLUMN_NUMBER_498
     , dummy DUMMY_COLUMN_NUMBER_499
     , dummy DUMMY_COLUMN_NUMBER_500
     , dummy DUMMY_COLUMN_NUMBER_501
     , dummy DUMMY_COLUMN_NUMBER_502
     , dummy DUMMY_COLUMN_NUMBER_503
     , dummy DUMMY_COLUMN_NUMBER_504
     , dummy DUMMY_COLUMN_NUMBER_505
     , dummy DUMMY_COLUMN_NUMBER_506
     , dummy DUMMY_COLUMN_NUMBER_507
     , dummy DUMMY_COLUMN_NUMBER_508
     , dummy DUMMY_COLUMN_NUMBER_509
     , dummy DUMMY_COLUMN_NUMBER_510
     , dummy DUMMY_COLUMN_NUMBER_511
     , dummy DUMMY_COLUMN_NUMBER_512
     , dummy DUMMY_COLUMN_NUMBER_513
     , dummy DUMMY_COLUMN_NUMBER_514
     , dummy DUMMY_COLUMN_NUMBER_515
     , dummy DUMMY_COLUMN_NUMBER_516
     , dummy DUMMY_COLUMN_NUMBER_517
     , dummy DUMMY_COLUMN_NUMBER_518
     , dummy DUMMY_COLUMN_NUMBER_519
     , dummy DUMMY_COLUMN_NUMBER_520
     , dummy DUMMY_COLUMN_NUMBER_521
     , dummy DUMMY_COLUMN_NUMBER_522
     , dummy DUMMY_COLUMN_NUMBER_523
     , dummy DUMMY_COLUMN_NUMBER_524
     , dummy DUMMY_COLUMN_NUMBER_525
     , dummy DUMMY_COLUMN_NUMBER_526
     , dummy DUMMY_COLUMN_NUMBER_527
     , dummy DUMMY_COLUMN_NUMBER_528
     , dummy DUMMY_COLUMN_NUMBER_529
     , dummy DUMMY_COLUMN_NUMBER_530
     , dummy DUMMY_COLUMN_NUMBER_531
     , dummy DUMMY_COLUMN_NUMBER_532
     , dummy DUMMY_COLUMN_NUMBER_533
     , dummy DUMMY_COLUMN_NUMBER_534
     , dummy DUMMY_COLUMN_NUMBER_535
     , dummy DUMMY_COLUMN_NUMBER_536
     , dummy DUMMY_COLUMN_NUMBER_537
     , dummy DUMMY_COLUMN_NUMBER_538
     , dummy DUMMY_COLUMN_NUMBER_539
     , dummy DUMMY_COLUMN_NUMBER_540
     , dummy DUMMY_COLUMN_NUMBER_541
     , dummy DUMMY_COLUMN_NUMBER_542
     , dummy DUMMY_COLUMN_NUMBER_543
     , dummy DUMMY_COLUMN_NUMBER_544
     , dummy DUMMY_COLUMN_NUMBER_545
     , dummy DUMMY_COLUMN_NUMBER_546
     , dummy DUMMY_COLUMN_NUMBER_547
     , dummy DUMMY_COLUMN_NUMBER_548
     , dummy DUMMY_COLUMN_NUMBER_549
     , dummy DUMMY_COLUMN_NUMBER_550
     , dummy DUMMY_COLUMN_NUMBER_551
     , dummy DUMMY_COLUMN_NUMBER_552
     , dummy DUMMY_COLUMN_NUMBER_553
     , dummy DUMMY_COLUMN_NUMBER_554
     , dummy DUMMY_COLUMN_NUMBER_555
     , dummy DUMMY_COLUMN_NUMBER_556
     , dummy DUMMY_COLUMN_NUMBER_557
     , dummy DUMMY_COLUMN_NUMBER_558
     , dummy DUMMY_COLUMN_NUMBER_559
     , dummy DUMMY_COLUMN_NUMBER_560
     , dummy DUMMY_COLUMN_NUMBER_561
     , dummy DUMMY_COLUMN_NUMBER_562
     , dummy DUMMY_COLUMN_NUMBER_563
     , dummy DUMMY_COLUMN_NUMBER_564
     , dummy DUMMY_COLUMN_NUMBER_565
     , dummy DUMMY_COLUMN_NUMBER_566
     , dummy DUMMY_COLUMN_NUMBER_567
     , dummy DUMMY_COLUMN_NUMBER_568
     , dummy DUMMY_COLUMN_NUMBER_569
     , dummy DUMMY_COLUMN_NUMBER_570
     , dummy DUMMY_COLUMN_NUMBER_571
     , dummy DUMMY_COLUMN_NUMBER_572
     , dummy DUMMY_COLUMN_NUMBER_573
     , dummy DUMMY_COLUMN_NUMBER_574
     , dummy DUMMY_COLUMN_NUMBER_575
     , dummy DUMMY_COLUMN_NUMBER_576
     , dummy DUMMY_COLUMN_NUMBER_577
     , dummy DUMMY_COLUMN_NUMBER_578
     , dummy DUMMY_COLUMN_NUMBER_579
     , dummy DUMMY_COLUMN_NUMBER_580
     , dummy DUMMY_COLUMN_NUMBER_581
     , dummy DUMMY_COLUMN_NUMBER_582
     , dummy DUMMY_COLUMN_NUMBER_583
     , dummy DUMMY_COLUMN_NUMBER_584
     , dummy DUMMY_COLUMN_NUMBER_585
     , dummy DUMMY_COLUMN_NUMBER_586
     , dummy DUMMY_COLUMN_NUMBER_587
     , dummy DUMMY_COLUMN_NUMBER_588
     , dummy DUMMY_COLUMN_NUMBER_589
     , dummy DUMMY_COLUMN_NUMBER_590
     , dummy DUMMY_COLUMN_NUMBER_591
     , dummy DUMMY_COLUMN_NUMBER_592
     , dummy DUMMY_COLUMN_NUMBER_593
     , dummy DUMMY_COLUMN_NUMBER_594
     , dummy DUMMY_COLUMN_NUMBER_595
     , dummy DUMMY_COLUMN_NUMBER_596
     , dummy DUMMY_COLUMN_NUMBER_597
     , dummy DUMMY_COLUMN_NUMBER_598
     , dummy DUMMY_COLUMN_NUMBER_599
     , dummy DUMMY_COLUMN_NUMBER_600}') || TO_CLOB(q'{
     , dummy DUMMY_COLUMN_NUMBER_601
     , dummy DUMMY_COLUMN_NUMBER_602
     , dummy DUMMY_COLUMN_NUMBER_603
     , dummy DUMMY_COLUMN_NUMBER_604
     , dummy DUMMY_COLUMN_NUMBER_605
     , dummy DUMMY_COLUMN_NUMBER_606
     , dummy DUMMY_COLUMN_NUMBER_607
     , dummy DUMMY_COLUMN_NUMBER_608
     , dummy DUMMY_COLUMN_NUMBER_609
     , dummy DUMMY_COLUMN_NUMBER_610
     , dummy DUMMY_COLUMN_NUMBER_611
     , dummy DUMMY_COLUMN_NUMBER_612
     , dummy DUMMY_COLUMN_NUMBER_613
     , dummy DUMMY_COLUMN_NUMBER_614
     , dummy DUMMY_COLUMN_NUMBER_615
     , dummy DUMMY_COLUMN_NUMBER_616
     , dummy DUMMY_COLUMN_NUMBER_617
     , dummy DUMMY_COLUMN_NUMBER_618
     , dummy DUMMY_COLUMN_NUMBER_619
     , dummy DUMMY_COLUMN_NUMBER_620
     , dummy DUMMY_COLUMN_NUMBER_621
     , dummy DUMMY_COLUMN_NUMBER_622
     , dummy DUMMY_COLUMN_NUMBER_623
     , dummy DUMMY_COLUMN_NUMBER_624
     , dummy DUMMY_COLUMN_NUMBER_625
     , dummy DUMMY_COLUMN_NUMBER_626
     , dummy DUMMY_COLUMN_NUMBER_627
     , dummy DUMMY_COLUMN_NUMBER_628
     , dummy DUMMY_COLUMN_NUMBER_629
     , dummy DUMMY_COLUMN_NUMBER_630
     , dummy DUMMY_COLUMN_NUMBER_631
     , dummy DUMMY_COLUMN_NUMBER_632
     , dummy DUMMY_COLUMN_NUMBER_633
     , dummy DUMMY_COLUMN_NUMBER_634
     , dummy DUMMY_COLUMN_NUMBER_635
     , dummy DUMMY_COLUMN_NUMBER_636
     , dummy DUMMY_COLUMN_NUMBER_637
     , dummy DUMMY_COLUMN_NUMBER_638
     , dummy DUMMY_COLUMN_NUMBER_639
     , dummy DUMMY_COLUMN_NUMBER_640
     , dummy DUMMY_COLUMN_NUMBER_641
     , dummy DUMMY_COLUMN_NUMBER_642
     , dummy DUMMY_COLUMN_NUMBER_643
     , dummy DUMMY_COLUMN_NUMBER_644
     , dummy DUMMY_COLUMN_NUMBER_645
     , dummy DUMMY_COLUMN_NUMBER_646
     , dummy DUMMY_COLUMN_NUMBER_647
     , dummy DUMMY_COLUMN_NUMBER_648
     , dummy DUMMY_COLUMN_NUMBER_649
     , dummy DUMMY_COLUMN_NUMBER_650
     , dummy DUMMY_COLUMN_NUMBER_651
     , dummy DUMMY_COLUMN_NUMBER_652
     , dummy DUMMY_COLUMN_NUMBER_653
     , dummy DUMMY_COLUMN_NUMBER_654
     , dummy DUMMY_COLUMN_NUMBER_655
     , dummy DUMMY_COLUMN_NUMBER_656
     , dummy DUMMY_COLUMN_NUMBER_657
     , dummy DUMMY_COLUMN_NUMBER_658
     , dummy DUMMY_COLUMN_NUMBER_659
     , dummy DUMMY_COLUMN_NUMBER_660
     , dummy DUMMY_COLUMN_NUMBER_661
     , dummy DUMMY_COLUMN_NUMBER_662
     , dummy DUMMY_COLUMN_NUMBER_663
     , dummy DUMMY_COLUMN_NUMBER_664
     , dummy DUMMY_COLUMN_NUMBER_665
     , dummy DUMMY_COLUMN_NUMBER_666
     , dummy DUMMY_COLUMN_NUMBER_667
     , dummy DUMMY_COLUMN_NUMBER_668
     , dummy DUMMY_COLUMN_NUMBER_669
     , dummy DUMMY_COLUMN_NUMBER_670
     , dummy DUMMY_COLUMN_NUMBER_671
     , dummy DUMMY_COLUMN_NUMBER_672
     , dummy DUMMY_COLUMN_NUMBER_673
     , dummy DUMMY_COLUMN_NUMBER_674
     , dummy DUMMY_COLUMN_NUMBER_675
     , dummy DUMMY_COLUMN_NUMBER_676
     , dummy DUMMY_COLUMN_NUMBER_677
     , dummy DUMMY_COLUMN_NUMBER_678
     , dummy DUMMY_COLUMN_NUMBER_679
     , dummy DUMMY_COLUMN_NUMBER_680
     , dummy DUMMY_COLUMN_NUMBER_681
     , dummy DUMMY_COLUMN_NUMBER_682
     , dummy DUMMY_COLUMN_NUMBER_683
     , dummy DUMMY_COLUMN_NUMBER_684
     , dummy DUMMY_COLUMN_NUMBER_685
     , dummy DUMMY_COLUMN_NUMBER_686
     , dummy DUMMY_COLUMN_NUMBER_687
     , dummy DUMMY_COLUMN_NUMBER_688
     , dummy DUMMY_COLUMN_NUMBER_689
     , dummy DUMMY_COLUMN_NUMBER_690
     , dummy DUMMY_COLUMN_NUMBER_691
     , dummy DUMMY_COLUMN_NUMBER_692
     , dummy DUMMY_COLUMN_NUMBER_693
     , dummy DUMMY_COLUMN_NUMBER_694
     , dummy DUMMY_COLUMN_NUMBER_695
     , dummy DUMMY_COLUMN_NUMBER_696
     , dummy DUMMY_COLUMN_NUMBER_697
     , dummy DUMMY_COLUMN_NUMBER_698
     , dummy DUMMY_COLUMN_NUMBER_699
     , dummy DUMMY_COLUMN_NUMBER_700
     , dummy DUMMY_COLUMN_NUMBER_701
     , dummy DUMMY_COLUMN_NUMBER_702
     , dummy DUMMY_COLUMN_NUMBER_703
     , dummy DUMMY_COLUMN_NUMBER_704
     , dummy DUMMY_COLUMN_NUMBER_705
     , dummy DUMMY_COLUMN_NUMBER_706
     , dummy DUMMY_COLUMN_NUMBER_707
     , dummy DUMMY_COLUMN_NUMBER_708
     , dummy DUMMY_COLUMN_NUMBER_709
     , dummy DUMMY_COLUMN_NUMBER_710
     , dummy DUMMY_COLUMN_NUMBER_711
     , dummy DUMMY_COLUMN_NUMBER_712
     , dummy DUMMY_COLUMN_NUMBER_713
     , dummy DUMMY_COLUMN_NUMBER_714
     , dummy DUMMY_COLUMN_NUMBER_715
     , dummy DUMMY_COLUMN_NUMBER_716
     , dummy DUMMY_COLUMN_NUMBER_717
     , dummy DUMMY_COLUMN_NUMBER_718
     , dummy DUMMY_COLUMN_NUMBER_719
     , dummy DUMMY_COLUMN_NUMBER_720
     , dummy DUMMY_COLUMN_NUMBER_721
     , dummy DUMMY_COLUMN_NUMBER_722
     , dummy DUMMY_COLUMN_NUMBER_723
     , dummy DUMMY_COLUMN_NUMBER_724
     , dummy DUMMY_COLUMN_NUMBER_725
     , dummy DUMMY_COLUMN_NUMBER_726
     , dummy DUMMY_COLUMN_NUMBER_727
     , dummy DUMMY_COLUMN_NUMBER_728
     , dummy DUMMY_COLUMN_NUMBER_729
     , dummy DUMMY_COLUMN_NUMBER_730
     , dummy DUMMY_COLUMN_NUMBER_731
     , dummy DUMMY_COLUMN_NUMBER_732
     , dummy DUMMY_COLUMN_NUMBER_733
     , dummy DUMMY_COLUMN_NUMBER_734
     , dummy DUMMY_COLUMN_NUMBER_735
     , dummy DUMMY_COLUMN_NUMBER_736
     , dummy DUMMY_COLUMN_NUMBER_737
     , dummy DUMMY_COLUMN_NUMBER_738
     , dummy DUMMY_COLUMN_NUMBER_739
     , dummy DUMMY_COLUMN_NUMBER_740
     , dummy DUMMY_COLUMN_NUMBER_741
     , dummy DUMMY_COLUMN_NUMBER_742
     , dummy DUMMY_COLUMN_NUMBER_743
     , dummy DUMMY_COLUMN_NUMBER_744
     , dummy DUMMY_COLUMN_NUMBER_745
     , dummy DUMMY_COLUMN_NUMBER_746
     , dummy DUMMY_COLUMN_NUMBER_747
     , dummy DUMMY_COLUMN_NUMBER_748
     , dummy DUMMY_COLUMN_NUMBER_749
     , dummy DUMMY_COLUMN_NUMBER_750
     , dummy DUMMY_COLUMN_NUMBER_751
     , dummy DUMMY_COLUMN_NUMBER_752
     , dummy DUMMY_COLUMN_NUMBER_753
     , dummy DUMMY_COLUMN_NUMBER_754
     , dummy DUMMY_COLUMN_NUMBER_755
     , dummy DUMMY_COLUMN_NUMBER_756
     , dummy DUMMY_COLUMN_NUMBER_757
     , dummy DUMMY_COLUMN_NUMBER_758
     , dummy DUMMY_COLUMN_NUMBER_759
     , dummy DUMMY_COLUMN_NUMBER_760
     , dummy DUMMY_COLUMN_NUMBER_761
     , dummy DUMMY_COLUMN_NUMBER_762
     , dummy DUMMY_COLUMN_NUMBER_763
     , dummy DUMMY_COLUMN_NUMBER_764
     , dummy DUMMY_COLUMN_NUMBER_765
     , dummy DUMMY_COLUMN_NUMBER_766
     , dummy DUMMY_COLUMN_NUMBER_767
     , dummy DUMMY_COLUMN_NUMBER_768
     , dummy DUMMY_COLUMN_NUMBER_769
     , dummy DUMMY_COLUMN_NUMBER_770
     , dummy DUMMY_COLUMN_NUMBER_771
     , dummy DUMMY_COLUMN_NUMBER_772
     , dummy DUMMY_COLUMN_NUMBER_773
     , dummy DUMMY_COLUMN_NUMBER_774
     , dummy DUMMY_COLUMN_NUMBER_775
     , dummy DUMMY_COLUMN_NUMBER_776
     , dummy DUMMY_COLUMN_NUMBER_777
     , dummy DUMMY_COLUMN_NUMBER_778
     , dummy DUMMY_COLUMN_NUMBER_779
     , dummy DUMMY_COLUMN_NUMBER_780
     , dummy DUMMY_COLUMN_NUMBER_781
     , dummy DUMMY_COLUMN_NUMBER_782
     , dummy DUMMY_COLUMN_NUMBER_783
     , dummy DUMMY_COLUMN_NUMBER_784
     , dummy DUMMY_COLUMN_NUMBER_785
     , dummy DUMMY_COLUMN_NUMBER_786
     , dummy DUMMY_COLUMN_NUMBER_787
     , dummy DUMMY_COLUMN_NUMBER_788
     , dummy DUMMY_COLUMN_NUMBER_789
     , dummy DUMMY_COLUMN_NUMBER_790
     , dummy DUMMY_COLUMN_NUMBER_791
     , dummy DUMMY_COLUMN_NUMBER_792
     , dummy DUMMY_COLUMN_NUMBER_793
     , dummy DUMMY_COLUMN_NUMBER_794
     , dummy DUMMY_COLUMN_NUMBER_795
     , dummy DUMMY_COLUMN_NUMBER_796
     , dummy DUMMY_COLUMN_NUMBER_797
     , dummy DUMMY_COLUMN_NUMBER_798
     , dummy DUMMY_COLUMN_NUMBER_799
     , dummy DUMMY_COLUMN_NUMBER_800}') || TO_CLOB(q'{
     , dummy DUMMY_COLUMN_NUMBER_801
     , dummy DUMMY_COLUMN_NUMBER_802
     , dummy DUMMY_COLUMN_NUMBER_803
     , dummy DUMMY_COLUMN_NUMBER_804
     , dummy DUMMY_COLUMN_NUMBER_805
     , dummy DUMMY_COLUMN_NUMBER_806
     , dummy DUMMY_COLUMN_NUMBER_807
     , dummy DUMMY_COLUMN_NUMBER_808
     , dummy DUMMY_COLUMN_NUMBER_809
     , dummy DUMMY_COLUMN_NUMBER_810
     , dummy DUMMY_COLUMN_NUMBER_811
     , dummy DUMMY_COLUMN_NUMBER_812
     , dummy DUMMY_COLUMN_NUMBER_813
     , dummy DUMMY_COLUMN_NUMBER_814
     , dummy DUMMY_COLUMN_NUMBER_815
     , dummy DUMMY_COLUMN_NUMBER_816
     , dummy DUMMY_COLUMN_NUMBER_817
     , dummy DUMMY_COLUMN_NUMBER_818
     , dummy DUMMY_COLUMN_NUMBER_819
     , dummy DUMMY_COLUMN_NUMBER_820
     , dummy DUMMY_COLUMN_NUMBER_821
     , dummy DUMMY_COLUMN_NUMBER_822
     , dummy DUMMY_COLUMN_NUMBER_823
     , dummy DUMMY_COLUMN_NUMBER_824
     , dummy DUMMY_COLUMN_NUMBER_825
     , dummy DUMMY_COLUMN_NUMBER_826
     , dummy DUMMY_COLUMN_NUMBER_827
     , dummy DUMMY_COLUMN_NUMBER_828
     , dummy DUMMY_COLUMN_NUMBER_829
     , dummy DUMMY_COLUMN_NUMBER_830
     , dummy DUMMY_COLUMN_NUMBER_831
     , dummy DUMMY_COLUMN_NUMBER_832
     , dummy DUMMY_COLUMN_NUMBER_833
     , dummy DUMMY_COLUMN_NUMBER_834
     , dummy DUMMY_COLUMN_NUMBER_835
     , dummy DUMMY_COLUMN_NUMBER_836
     , dummy DUMMY_COLUMN_NUMBER_837
     , dummy DUMMY_COLUMN_NUMBER_838
     , dummy DUMMY_COLUMN_NUMBER_839
     , dummy DUMMY_COLUMN_NUMBER_840
     , dummy DUMMY_COLUMN_NUMBER_841
     , dummy DUMMY_COLUMN_NUMBER_842
     , dummy DUMMY_COLUMN_NUMBER_843
     , dummy DUMMY_COLUMN_NUMBER_844
     , dummy DUMMY_COLUMN_NUMBER_845
     , dummy DUMMY_COLUMN_NUMBER_846
     , dummy DUMMY_COLUMN_NUMBER_847
     , dummy DUMMY_COLUMN_NUMBER_848
     , dummy DUMMY_COLUMN_NUMBER_849
     , dummy DUMMY_COLUMN_NUMBER_850
     , dummy DUMMY_COLUMN_NUMBER_851
     , dummy DUMMY_COLUMN_NUMBER_852
     , dummy DUMMY_COLUMN_NUMBER_853
     , dummy DUMMY_COLUMN_NUMBER_854
     , dummy DUMMY_COLUMN_NUMBER_855
     , dummy DUMMY_COLUMN_NUMBER_856
     , dummy DUMMY_COLUMN_NUMBER_857
     , dummy DUMMY_COLUMN_NUMBER_858
     , dummy DUMMY_COLUMN_NUMBER_859
     , dummy DUMMY_COLUMN_NUMBER_860
     , dummy DUMMY_COLUMN_NUMBER_861
     , dummy DUMMY_COLUMN_NUMBER_862
     , dummy DUMMY_COLUMN_NUMBER_863
     , dummy DUMMY_COLUMN_NUMBER_864
     , dummy DUMMY_COLUMN_NUMBER_865
     , dummy DUMMY_COLUMN_NUMBER_866
     , dummy DUMMY_COLUMN_NUMBER_867
     , dummy DUMMY_COLUMN_NUMBER_868
     , dummy DUMMY_COLUMN_NUMBER_869
     , dummy DUMMY_COLUMN_NUMBER_870
     , dummy DUMMY_COLUMN_NUMBER_871
     , dummy DUMMY_COLUMN_NUMBER_872
     , dummy DUMMY_COLUMN_NUMBER_873
     , dummy DUMMY_COLUMN_NUMBER_874
     , dummy DUMMY_COLUMN_NUMBER_875
     , dummy DUMMY_COLUMN_NUMBER_876
     , dummy DUMMY_COLUMN_NUMBER_877
     , dummy DUMMY_COLUMN_NUMBER_878
     , dummy DUMMY_COLUMN_NUMBER_879
     , dummy DUMMY_COLUMN_NUMBER_880
     , dummy DUMMY_COLUMN_NUMBER_881
     , dummy DUMMY_COLUMN_NUMBER_882
     , dummy DUMMY_COLUMN_NUMBER_883
     , dummy DUMMY_COLUMN_NUMBER_884
     , dummy DUMMY_COLUMN_NUMBER_885
     , dummy DUMMY_COLUMN_NUMBER_886
     , dummy DUMMY_COLUMN_NUMBER_887
     , dummy DUMMY_COLUMN_NUMBER_888
     , dummy DUMMY_COLUMN_NUMBER_889
     , dummy DUMMY_COLUMN_NUMBER_890
     , dummy DUMMY_COLUMN_NUMBER_891
     , dummy DUMMY_COLUMN_NUMBER_892
     , dummy DUMMY_COLUMN_NUMBER_893
     , dummy DUMMY_COLUMN_NUMBER_894
     , dummy DUMMY_COLUMN_NUMBER_895
     , dummy DUMMY_COLUMN_NUMBER_896
     , dummy DUMMY_COLUMN_NUMBER_897
     , dummy DUMMY_COLUMN_NUMBER_898
     , dummy DUMMY_COLUMN_NUMBER_899
     , dummy DUMMY_COLUMN_NUMBER_900
     , dummy DUMMY_COLUMN_NUMBER_901
     , dummy DUMMY_COLUMN_NUMBER_902
     , dummy DUMMY_COLUMN_NUMBER_903
     , dummy DUMMY_COLUMN_NUMBER_904
     , dummy DUMMY_COLUMN_NUMBER_905
     , dummy DUMMY_COLUMN_NUMBER_906
     , dummy DUMMY_COLUMN_NUMBER_907
     , dummy DUMMY_COLUMN_NUMBER_908
     , dummy DUMMY_COLUMN_NUMBER_909
     , dummy DUMMY_COLUMN_NUMBER_910
     , dummy DUMMY_COLUMN_NUMBER_911
     , dummy DUMMY_COLUMN_NUMBER_912
     , dummy DUMMY_COLUMN_NUMBER_913
     , dummy DUMMY_COLUMN_NUMBER_914
     , dummy DUMMY_COLUMN_NUMBER_915
     , dummy DUMMY_COLUMN_NUMBER_916
     , dummy DUMMY_COLUMN_NUMBER_917
     , dummy DUMMY_COLUMN_NUMBER_918
     , dummy DUMMY_COLUMN_NUMBER_919
     , dummy DUMMY_COLUMN_NUMBER_920
     , dummy DUMMY_COLUMN_NUMBER_921
     , dummy DUMMY_COLUMN_NUMBER_922
     , dummy DUMMY_COLUMN_NUMBER_923
     , dummy DUMMY_COLUMN_NUMBER_924
     , dummy DUMMY_COLUMN_NUMBER_925
     , dummy DUMMY_COLUMN_NUMBER_926
     , dummy DUMMY_COLUMN_NUMBER_927
     , dummy DUMMY_COLUMN_NUMBER_928
     , dummy DUMMY_COLUMN_NUMBER_929
     , dummy DUMMY_COLUMN_NUMBER_930
     , dummy DUMMY_COLUMN_NUMBER_931
     , dummy DUMMY_COLUMN_NUMBER_932
     , dummy DUMMY_COLUMN_NUMBER_933
     , dummy DUMMY_COLUMN_NUMBER_934
     , dummy DUMMY_COLUMN_NUMBER_935
     , dummy DUMMY_COLUMN_NUMBER_936
     , dummy DUMMY_COLUMN_NUMBER_937
     , dummy DUMMY_COLUMN_NUMBER_938
     , dummy DUMMY_COLUMN_NUMBER_939
     , dummy DUMMY_COLUMN_NUMBER_940
     , dummy DUMMY_COLUMN_NUMBER_941
     , dummy DUMMY_COLUMN_NUMBER_942
     , dummy DUMMY_COLUMN_NUMBER_943
     , dummy DUMMY_COLUMN_NUMBER_944
     , dummy DUMMY_COLUMN_NUMBER_945
     , dummy DUMMY_COLUMN_NUMBER_946
     , dummy DUMMY_COLUMN_NUMBER_947
     , dummy DUMMY_COLUMN_NUMBER_948
     , dummy DUMMY_COLUMN_NUMBER_949
     , dummy DUMMY_COLUMN_NUMBER_950
     , dummy DUMMY_COLUMN_NUMBER_951
     , dummy DUMMY_COLUMN_NUMBER_952
     , dummy DUMMY_COLUMN_NUMBER_953
     , dummy DUMMY_COLUMN_NUMBER_954
     , dummy DUMMY_COLUMN_NUMBER_955
     , dummy DUMMY_COLUMN_NUMBER_956
     , dummy DUMMY_COLUMN_NUMBER_957
     , dummy DUMMY_COLUMN_NUMBER_958
     , dummy DUMMY_COLUMN_NUMBER_959
     , dummy DUMMY_COLUMN_NUMBER_960
     , dummy DUMMY_COLUMN_NUMBER_961
     , dummy DUMMY_COLUMN_NUMBER_962
     , dummy DUMMY_COLUMN_NUMBER_963
     , dummy DUMMY_COLUMN_NUMBER_964
     , dummy DUMMY_COLUMN_NUMBER_965
     , dummy DUMMY_COLUMN_NUMBER_966
     , dummy DUMMY_COLUMN_NUMBER_967
     , dummy DUMMY_COLUMN_NUMBER_968
     , dummy DUMMY_COLUMN_NUMBER_969
     , dummy DUMMY_COLUMN_NUMBER_970
     , dummy DUMMY_COLUMN_NUMBER_971
     , dummy DUMMY_COLUMN_NUMBER_972
     , dummy DUMMY_COLUMN_NUMBER_973
     , dummy DUMMY_COLUMN_NUMBER_974
     , dummy DUMMY_COLUMN_NUMBER_975
     , dummy DUMMY_COLUMN_NUMBER_976
     , dummy DUMMY_COLUMN_NUMBER_977
     , dummy DUMMY_COLUMN_NUMBER_978
     , dummy DUMMY_COLUMN_NUMBER_979
     , dummy DUMMY_COLUMN_NUMBER_980
     , dummy DUMMY_COLUMN_NUMBER_981
     , dummy DUMMY_COLUMN_NUMBER_982
     , dummy DUMMY_COLUMN_NUMBER_983
     , dummy DUMMY_COLUMN_NUMBER_984
     , dummy DUMMY_COLUMN_NUMBER_985
     , dummy DUMMY_COLUMN_NUMBER_986
     , dummy DUMMY_COLUMN_NUMBER_987
     , dummy DUMMY_COLUMN_NUMBER_988
     , dummy DUMMY_COLUMN_NUMBER_989
     , dummy DUMMY_COLUMN_NUMBER_990
     , dummy DUMMY_COLUMN_NUMBER_991
     , dummy DUMMY_COLUMN_NUMBER_992
     , dummy DUMMY_COLUMN_NUMBER_993
     , dummy DUMMY_COLUMN_NUMBER_994
     , dummy DUMMY_COLUMN_NUMBER_995
     , dummy DUMMY_COLUMN_NUMBER_996
     , dummy DUMMY_COLUMN_NUMBER_997
     , dummy DUMMY_COLUMN_NUMBER_998
     , dummy DUMMY_COLUMN_NUMBER_999
     , dummy DUMMY_COLUMN_NUMBER_1000
     , dummy DUMMY_COLUMN_NUMBER_1001
     , dummy DUMMY_COLUMN_NUMBER_1002
     , dummy DUMMY_COLUMN_NUMBER_1003
     , dummy DUMMY_COLUMN_NUMBER_1004
     , dummy DUMMY_COLUMN_NUMBER_1005
     , dummy DUMMY_COLUMN_NUMBER_1006
     , dummy DUMMY_COLUMN_NUMBER_1007
     , dummy DUMMY_COLUMN_NUMBER_1008
     , dummy DUMMY_COLUMN_NUMBER_1009
     , dummy DUMMY_COLUMN_NUMBER_1010
     , dummy DUMMY_COLUMN_NUMBER_1011
     , dummy DUMMY_COLUMN_NUMBER_1012
     , dummy DUMMY_COLUMN_NUMBER_1013
     , dummy DUMMY_COLUMN_NUMBER_1014
     , dummy DUMMY_COLUMN_NUMBER_1015
     , dummy DUMMY_COLUMN_NUMBER_1016
     , dummy DUMMY_COLUMN_NUMBER_1017
     , dummy DUMMY_COLUMN_NUMBER_1018
     , dummy DUMMY_COLUMN_NUMBER_1019
     , dummy DUMMY_COLUMN_NUMBER_1020
     , dummy DUMMY_COLUMN_NUMBER_1021
     , dummy DUMMY_COLUMN_NUMBER_1022
     , dummy DUMMY_COLUMN_NUMBER_1023
     , dummy DUMMY_COLUMN_NUMBER_1024
from dual }');
       
    dbms_utility.expand_sql_text(
        input_sql_text => v_input
      , output_sql_text => v_output
    );
    
    declare
      v_offset integer := 1;
      PRINT_MAX_CHARS_EACH_LOOP constant positiven := 32767;
      v_clob_length integer;
      v_chunk varchar2(32767);
      v_next_newline_pos pls_integer;
    begin
    
      v_clob_length := dbms_lob.getlength(v_output);
      
      -- Make it so that dbms_output.put_line has no limit.
      dbms_output.enable(null);
    
      <<loop_over_clob_and_print>>
      loop
        exit when v_offset > v_clob_length;
        
        
        -- Peel off a 32k chunk of our lob.
        v_chunk := dbms_lob.substr(v_output, PRINT_MAX_CHARS_EACH_LOOP, v_offset);
        
        -- Start searching from the back end of our lob a newline.
        v_next_newline_pos := instr(v_chunk, chr(10), -1);
        
        -- If we didn't find a new line (which, we likely won't, we're forced to inject a newline after 32767 characters,
        -- since DBMS_OUTPUT.PUT_LINE has a hardwired limit of 32767 chars per newline...
        if v_next_newline_pos <= 0 then
          dbms_output.put_line(v_chunk);
          v_offset := v_offset + PRINT_MAX_CHARS_EACH_LOOP;
          
        -- ...but if we *did* find a newline, then 
        else
          --back up to right *before* the newline
          v_next_newline_pos := v_next_newline_pos - 1;
          --print the line (put_line will add the newline at the end)
          dbms_output.put_line(substr(v_chunk, 1, v_next_newline_pos));
          -- skip to right after the new line, so we can start grabbing the next chunk there.
          v_offset := v_offset + v_next_newline_pos + 1;
        end if;

      end loop loop_over_clob_and_print;
    end;
  
  $end
end;
/

Free Oracle SQL Tuning Guide

Check out my FREE guide! 7 SQL Tuning Secrets You Can Use Immediately, Even If You’ve Never Tuned a Query In Your Life!

Get it here: tuningsql.com/secrets

7 SQL Tuning Secrets You can Use Immediately, Even If You've Never Tuned A Query In Your Life
http://tuningsql.com/secrets

Leave a Reply

Your email address will not be published. Required fields are marked *