CREATE OR REPLACE TYPE obj_typ AS OBJECT (col1 number,
col2 number,
col3 number,
col4 number,
col5 number,
col6 number,
col7 number,
col8 number,
col9 number,
col10 number,
col11 number,
col12 number,
col13 number,
col14 number,
col15 number,
col16 number,
col17 number,
col18 number,
col19 number,
col20 number,
col21 number,
col22 number,
col23 number,
col24 number,
col25 number,
col26 number,
col27 number,
col28 number,
col29 number,
col30 number,
col31 number,
col32 number,
col33 number,
col34 number,
col35 number,
col36 number,
col37 number,
col38 number,
col39 number,
col40 number,
col41 number,
col42 number,
col43 number,
col44 number,
col45 number,
col46 number,
col47 number,
col48 number,
col49 number,
col50 number,
col51 number,
col52 number,
col53 number,
col54 number,
col55 number,
col56 number,
col57 number,
col58 number,
col59 number,
col60 number,
col61 number,
col62 number,
col63 number,
col64 number,
col65 number,
col66 number,
col67 number,
col68 number,
col69 number,
col70 number,
col71 number,
col72 number,
col73 number,
col74 number,
col75 number,
col76 number,
col77 number,
col78 number,
col79 number,
col80 number,
col81 number,
col82 number,
col83 number,
col84 number,
col85 number,
col86 number,
col87 number,
col88 number,
col89 number,
col90 number,
col91 number,
col92 number,
col93 number,
col94 number,
col95 number,
col96 number,
col97 number,
col98 number,
col99 number,
col100 number,
col101 number,
col102 number,
col103 number,
col104 number,
col105 number,
col106 number,
col107 number,
col108 number,
col109 number,
col110 number,
col111 number,
col112 number,
col113 number,
col114 number,
col115 number,
col116 number,
col117 number,
col118 number,
col119 number,
col120 number,
col121 number,
col122 number,
col123 number,
col124 number,
col125 number,
col126 number,
col127 number,
col128 number,
col129 number,
col130 number,
col131 number,
col132 number,
col133 number,
col134 number,
col135 number,
col136 number,
col137 number,
col138 number,
col139 number,
col140 number,
col141 number,
col142 number,
col143 number,
col144 number,
col145 number,
col146 number,
col147 number,
col148 number,
col149 number,
col150 number,
col151 number,
col152 number,
col153 number,
col154 number,
col155 number,
col156 number,
col157 number,
col158 number,
col159 number,
col160 number,
col161 number,
col162 number,
col163 number,
col164 number,
col165 number,
col166 number,
col167 number,
col168 number,
col169 number,
col170 number,
col171 number,
col172 number,
col173 number,
col174 number,
col175 number,
col176 number,
col177 number,
col178 number,
col179 number,
col180 number,
col181 number,
col182 number,
col183 number,
col184 number,
col185 number,
col186 number,
col187 number,
col188 number,
col189 number,
col190 number,
col191 number,
col192 number,
col193 number,
col194 number,
col195 number,
col196 number,
col197 number,
col198 number,
col199 number,
col200 number,
col201 number,
col202 number,
col203 number,
col204 number,
col205 number,
col206 number,
col207 number,
col208 number,
col209 number,
col210 number,
col211 number,
col212 number,
col213 number,
col214 number,
col215 number,
col216 number,
col217 number,
col218 number,
col219 number,
col220 number,
col221 number,
col222 number,
col223 number,
col224 number,
col225 number,
col226 number,
col227 number,
col228 number,
col229 number,
col230 number,
col231 number,
col232 number,
col233 number,
col234 number,
col235 number,
col236 number,
col237 number,
col238 number,
col239 number,
col240 number,
col241 number,
col242 number,
col243 number,
col244 number,
col245 number,
col246 number,
col247 number,
col248 number,
col249 number,
col250 number,
col251 number,
col252 number,
col253 number,
col254 number,
col255 number,
col256 number,
col257 number,
col258 number,
col259 number,
col260 number,
col261 number,
col262 number,
col263 number,
col264 number,
col265 number,
col266 number,
col267 number,
col268 number,
col269 number,
col270 number,
col271 number,
col272 number,
col273 number,
col274 number,
col275 number,
col276 number,
col277 number,
col278 number,
col279 number,
col280 number,
col281 number,
col282 number,
col283 number,
col284 number,
col285 number,
col286 number,
col287 number,
col288 number,
col289 number,
col290 number,
col291 number,
col292 number,
col293 number,
col294 number,
col295 number,
col296 number,
col297 number,
col298 number,
col299 number,
col300 number,
col301 number,
col302 number,
col303 number,
col304 number,
col305 number,
col306 number,
col307 number,
col308 number,
col309 number,
col310 number,
col311 number,
col312 number,
col313 number,
col314 number,
col315 number,
col316 number,
col317 number,
col318 number,
col319 number,
col320 number,
col321 number,
col322 number,
col323 number,
col324 number,
col325 number,
col326 number,
col327 number,
col328 number,
col329 number,
col330 number,
col331 number,
col332 number,
col333 number,
col334 number,
col335 number,
col336 number,
col337 number,
col338 number,
col339 number,
col340 number,
col341 number,
col342 number,
col343 number,
col344 number,
col345 number,
col346 number,
col347 number,
col348 number,
col349 number,
col350 number,
col351 number,
col352 number,
col353 number,
col354 number,
col355 number,
col356 number,
col357 number,
col358 number,
col359 number,
col360 number,
col361 number,
col362 number,
col363 number,
col364 number,
col365 number,
col366 number,
col367 number,
col368 number,
col369 number,
col370 number,
col371 number,
col372 number,
col373 number,
col374 number,
col375 number,
col376 number,
col377 number,
col378 number,
col379 number,
col380 number,
col381 number,
col382 number,
col383 number,
col384 number,
col385 number,
col386 number,
col387 number,
col388 number,
col389 number,
col390 number,
col391 number,
col392 number,
col393 number,
col394 number,
col395 number,
col396 number,
col397 number,
col398 number,
col399 number,
col400 number,
col401 number,
col402 number,
col403 number,
col404 number,
col405 number,
col406 number,
col407 number,
col408 number,
col409 number,
col410 number,
col411 number,
col412 number,
col413 number,
col414 number,
col415 number,
col416 number,
col417 number,
col418 number,
col419 number,
col420 number,
col421 number,
col422 number,
col423 number,
col424 number,
col425 number,
col426 number,
col427 number,
col428 number,
col429 number,
col430 number,
col431 number,
col432 number,
col433 number,
col434 number,
col435 number,
col436 number,
col437 number,
col438 number,
col439 number,
col440 number,
col441 number,
col442 number,
col443 number,
col444 number,
col445 number,
col446 number,
col447 number,
col448 number,
col449 number,
col450 number,
col451 number,
col452 number,
col453 number,
col454 number,
col455 number,
col456 number,
col457 number,
col458 number,
col459 number,
col460 number,
col461 number,
col462 number,
col463 number,
col464 number,
col465 number,
col466 number,
col467 number,
col468 number,
col469 number,
col470 number,
col471 number,
col472 number,
col473 number,
col474 number,
col475 number,
col476 number,
col477 number,
col478 number,
col479 number,
col480 number,
col481 number,
col482 number,
col483 number,
col484 number,
col485 number,
col486 number,
col487 number,
col488 number,
col489 number,
col490 number,
col491 number,
col492 number,
col493 number,
col494 number,
col495 number,
col496 number,
col497 number,
col498 number,
col499 number,
col500 NUMBER,
col501 number,
col502 number,
col503 number,
col504 number,
col505 number,
col506 number,
col507 number,
col508 number,
col509 number,
col510 number,
col511 number,
col512 number,
col513 number,
col514 number,
col515 number,
col516 number,
col517 number,
col518 number,
col519 number,
col520 number,
col521 number,
col522 number,
col523 number,
col524 number,
col525 number,
col526 number,
col527 number,
col528 number,
col529 number,
col530 number,
col531 number,
col532 number,
col533 number,
col534 number,
col535 number,
col536 number,
col537 number,
col538 number,
col539 number,
col540 number,
col541 number,
col542 number,
col543 number,
col544 number,
col545 number,
col546 number,
col547 number,
col548 number,
col549 number,
col550 number,
col551 number,
col552 number,
col553 number,
col554 number,
col555 number,
col556 number,
col557 number,
col558 number,
col559 number,
col560 number,
col561 number,
col562 number,
col563 number,
col564 number,
col565 number,
col566 number,
col567 number,
col568 number,
col569 number,
col570 number,
col571 number,
col572 number,
col573 number,
col574 number,
col575 number,
col576 number,
col577 number,
col578 number,
col579 number,
col580 number,
col581 number,
col582 number,
col583 number,
col584 number,
col585 number,
col586 number,
col587 number,
col588 number,
col589 number,
col590 number,
col591 number,
col592 number,
col593 number,
col594 number,
col595 number,
col596 number,
col597 number,
col598 number,
col599 number,
col600 number,
col601 number,
col602 number,
col603 number,
col604 number,
col605 number,
col606 number,
col607 number,
col608 number,
col609 number,
col610 number,
col611 number,
col612 number,
col613 number,
col614 number,
col615 number,
col616 number,
col617 number,
col618 number,
col619 number,
col620 number,
col621 number,
col622 number,
col623 number,
col624 number,
col625 number,
col626 number,
col627 number,
col628 number,
col629 number,
col630 number,
col631 number,
col632 number,
col633 number,
col634 number,
col635 number,
col636 number,
col637 number,
col638 number,
col639 number,
col640 number,
col641 number,
col642 number,
col643 number,
col644 number,
col645 number,
col646 number,
col647 number,
col648 number,
col649 number,
col650 number,
col651 number,
col652 number,
col653 number,
col654 number,
col655 number,
col656 number,
col657 number,
col658 number,
col659 number,
col660 number,
col661 number,
col662 number,
col663 number,
col664 number,
col665 number,
col666 number,
col667 number,
col668 number,
col669 number,
col670 number,
col671 number,
col672 number,
col673 number,
col674 number,
col675 number,
col676 number,
col677 number,
col678 number,
col679 number,
col680 number,
col681 number,
col682 number,
col683 number,
col684 number,
col685 number,
col686 number,
col687 number,
col688 number,
col689 number,
col690 number,
col691 number,
col692 number,
col693 number,
col694 number,
col695 number,
col696 number,
col697 number,
col698 number,
col699 number,
col700 number,
col701 number,
col702 number,
col703 number,
col704 number,
col705 number,
col706 number,
col707 number,
col708 number,
col709 number,
col710 number,
col711 number,
col712 number,
col713 number,
col714 number,
col715 number,
col716 number,
col717 number,
col718 number,
col719 number,
col720 number,
col721 number,
col722 number,
col723 number,
col724 number,
col725 number,
col726 number,
col727 number,
col728 number,
col729 number,
col730 number,
col731 number,
col732 number,
col733 number,
col734 number,
col735 number,
col736 number,
col737 number,
col738 number,
col739 number,
col740 number,
col741 number,
col742 number,
col743 number,
col744 number,
col745 number,
col746 number,
col747 number,
col748 number,
col749 number,
col750 number,
col751 number,
col752 number,
col753 number,
col754 number,
col755 number,
col756 number,
col757 number,
col758 number,
col759 number,
col760 number,
col761 number,
col762 number,
col763 number,
col764 number,
col765 number,
col766 number,
col767 number,
col768 number,
col769 number,
col770 number,
col771 number,
col772 number,
col773 number,
col774 number,
col775 number,
col776 number,
col777 number,
col778 number,
col779 number,
col780 number,
col781 number,
col782 number,
col783 number,
col784 number,
col785 number,
col786 number,
col787 number,
col788 number,
col789 number,
col790 number,
col791 number,
col792 number,
col793 number,
col794 number,
col795 number,
col796 number,
col797 number,
col798 number,
col799 number,
col800 number,
col801 number,
col802 number,
col803 number,
col804 number,
col805 number,
col806 number,
col807 number,
col808 number,
col809 number,
col810 number,
col811 number,
col812 number,
col813 number,
col814 number,
col815 number,
col816 number,
col817 number,
col818 number,
col819 number,
col820 number,
col821 number,
col822 number,
col823 number,
col824 number,
col825 number,
col826 number,
col827 number,
col828 number,
col829 number,
col830 number,
col831 number,
col832 number,
col833 number,
col834 number,
col835 number,
col836 number,
col837 number,
col838 number,
col839 number,
col840 number,
col841 number,
col842 number,
col843 number,
col844 number,
col845 number,
col846 number,
col847 number,
col848 number,
col849 number,
col850 number,
col851 number,
col852 number,
col853 number,
col854 number,
col855 number,
col856 number,
col857 number,
col858 number,
col859 number,
col860 number,
col861 number,
col862 number,
col863 number,
col864 number,
col865 number,
col866 number,
col867 number,
col868 number,
col869 number,
col870 number,
col871 number,
col872 number,
col873 number,
col874 number,
col875 number,
col876 number,
col877 number,
col878 number,
col879 number,
col880 number,
col881 number,
col882 number,
col883 number,
col884 number,
col885 number,
col886 number,
col887 number,
col888 number,
col889 number,
col890 number,
col891 number,
col892 number,
col893 number,
col894 number,
col895 number,
col896 number,
col897 number,
col898 number,
col899 number,
col900 number,
col901 number,
col902 number,
col903 number,
col904 number,
col905 number,
col906 number,
col907 number,
col908 number,
col909 number,
col910 number,
col911 number,
col912 number,
col913 number,
col914 number,
col915 number,
col916 number,
col917 number,
col918 number,
col919 number,
col920 number,
col921 number,
col922 number,
col923 number,
col924 number,
col925 number,
col926 number,
col927 number,
col928 number,
col929 number,
col930 number,
col931 number,
col932 number,
col933 number,
col934 number,
col935 number,
col936 number,
col937 number,
col938 number,
col939 number,
col940 number,
col941 number,
col942 number,
col943 number,
col944 number,
col945 number,
col946 number,
col947 number,
col948 number,
col949 number,
col950 number,
col951 number,
col952 number,
col953 number,
col954 number,
col955 number,
col956 number,
col957 number,
col958 number,
col959 number,
col960 number,
col961 number,
col962 number,
col963 number,
col964 number,
col965 number,
col966 number,
col967 number,
col968 number,
col969 number,
col970 number,
col971 number,
col972 number,
col973 number,
col974 number,
col975 number,
col976 number,
col977 number,
col978 number,
col979 number,
col980 number,
col981 number,
col982 number,
col983 number,
col984 number,
col985 number,
col986 number,
col987 number,
col988 number,
col989 number,
col990 number,
col991 number,
col992 number,
col993 number,
col994 number,
col995 number,
col996 number,
col997 number,
col998 number,
col999 NUMBER,
col1000 NUMBER
);
CREATE OR REPLACE TYPE col_typ AS TABLE OF obj_typ;
DECLARE
var_typ col_typ;
BEGIN
SELECT obj_typ(1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16,
17,
18,
19,
20,
21,
22,
23,
24,
25,
26,
27,
28,
29,
30,
31,
32,
33,
34,
35,
36,
37,
38,
39,
40,
41,
42,
43,
44,
45,
46,
47,
48,
49,
50,
51,
52,
53,
54,
55,
56,
57,
58,
59,
60,
61,
62,
63,
64,
65,
66,
67,
68,
69,
70,
71,
72,
73,
74,
75,
76,
77,
78,
79,
80,
81,
82,
83,
84,
85,
86,
87,
88,
89,
90,
91,
92,
93,
94,
95,
96,
97,
98,
99,
100,
101,
102,
103,
104,
105,
106,
107,
108,
109,
110,
111,
112,
113,
114,
115,
116,
117,
118,
119,
120,
121,
122,
123,
124,
125,
126,
127,
128,
129,
130,
131,
132,
133,
134,
135,
136,
137,
138,
139,
140,
141,
142,
143,
144,
145,
146,
147,
148,
149,
150,
151,
152,
153,
154,
155,
156,
157,
158,
159,
160,
161,
162,
163,
164,
165,
166,
167,
168,
169,
170,
171,
172,
173,
174,
175,
176,
177,
178,
179,
180,
181,
182,
183,
184,
185,
186,
187,
188,
189,
190,
191,
192,
193,
194,
195,
196,
197,
198,
199,
200,
201,
202,
203,
204,
205,
206,
207,
208,
209,
210,
211,
212,
213,
214,
215,
216,
217,
218,
219,
220,
221,
222,
223,
224,
225,
226,
227,
228,
229,
230,
231,
232,
233,
234,
235,
236,
237,
238,
239,
240,
241,
242,
243,
244,
245,
246,
247,
248,
249,
250,
251,
252,
253,
254,
255,
256,
257,
258,
259,
260,
261,
262,
263,
264,
265,
266,
267,
268,
269,
270,
271,
272,
273,
274,
275,
276,
277,
278,
279,
280,
281,
282,
283,
284,
285,
286,
287,
288,
289,
290,
291,
292,
293,
294,
295,
296,
297,
298,
299,
300,
301,
302,
303,
304,
305,
306,
307,
308,
309,
310,
311,
312,
313,
314,
315,
316,
317,
318,
319,
320,
321,
322,
323,
324,
325,
326,
327,
328,
329,
330,
331,
332,
333,
334,
335,
336,
337,
338,
339,
340,
341,
342,
343,
344,
345,
346,
347,
348,
349,
350,
351,
352,
353,
354,
355,
356,
357,
358,
359,
360,
361,
362,
363,
364,
365,
366,
367,
368,
369,
370,
371,
372,
373,
374,
375,
376,
377,
378,
379,
380,
381,
382,
383,
384,
385,
386,
387,
388,
389,
390,
391,
392,
393,
394,
395,
396,
397,
398,
399,
400,
401,
402,
403,
404,
405,
406,
407,
408,
409,
410,
411,
412,
413,
414,
415,
416,
417,
418,
419,
420,
421,
422,
423,
424,
425,
426,
427,
428,
429,
430,
431,
432,
433,
434,
435,
436,
437,
438,
439,
440,
441,
442,
443,
444,
445,
446,
447,
448,
449,
450,
451,
452,
453,
454,
455,
456,
457,
458,
459,
460,
461,
462,
463,
464,
465,
466,
467,
468,
469,
470,
471,
472,
473,
474,
475,
476,
477,
478,
479,
480,
481,
482,
483,
484,
485,
486,
487,
488,
489,
490,
491,
492,
493,
494,
495,
496,
497,
498,
499,
500,
501,
502,
503,
504,
505,
506,
507,
508,
509,
510,
511,
512,
513,
514,
515,
516,
517,
518,
519,
520,
521,
522,
523,
524,
525,
526,
527,
528,
529,
530,
531,
532,
533,
534,
535,
536,
537,
538,
539,
540,
541,
542,
543,
544,
545,
546,
547,
548,
549,
550,
551,
552,
553,
554,
555,
556,
557,
558,
559,
560,
561,
562,
563,
564,
565,
566,
567,
568,
569,
570,
571,
572,
573,
574,
575,
576,
577,
578,
579,
580,
581,
582,
583,
584,
585,
586,
587,
588,
589,
590,
591,
592,
593,
594,
595,
596,
597,
598,
599,
600,
601,
602,
603,
604,
605,
606,
607,
608,
609,
610,
611,
612,
613,
614,
615,
616,
617,
618,
619,
620,
621,
622,
623,
624,
625,
626,
627,
628,
629,
630,
631,
632,
633,
634,
635,
636,
637,
638,
639,
640,
641,
642,
643,
644,
645,
646,
647,
648,
649,
650,
651,
652,
653,
654,
655,
656,
657,
658,
659,
660,
661,
662,
663,
664,
665,
666,
667,
668,
669,
670,
671,
672,
673,
674,
675,
676,
677,
678,
679,
680,
681,
682,
683,
684,
685,
686,
687,
688,
689,
690,
691,
692,
693,
694,
695,
696,
697,
698,
699,
700,
701,
702,
703,
704,
705,
706,
707,
708,
709,
710,
711,
712,
713,
714,
715,
716,
717,
718,
719,
720,
721,
722,
723,
724,
725,
726,
727,
728,
729,
730,
731,
732,
733,
734,
735,
736,
737,
738,
739,
740,
741,
742,
743,
744,
745,
746,
747,
748,
749,
750,
751,
752,
753,
754,
755,
756,
757,
758,
759,
760,
761,
762,
763,
764,
765,
766,
767,
768,
769,
770,
771,
772,
773,
774,
775,
776,
777,
778,
779,
780,
781,
782,
783,
784,
785,
786,
787,
788,
789,
790,
791,
792,
793,
794,
795,
796,
797,
798,
799,
800,
801,
802,
803,
804,
805,
806,
807,
808,
809,
810,
811,
812,
813,
814,
815,
816,
817,
818,
819,
820,
821,
822,
823,
824,
825,
826,
827,
828,
829,
830,
831,
832,
833,
834,
835,
836,
837,
838,
839,
840,
841,
842,
843,
844,
845,
846,
847,
848,
849,
850,
851,
852,
853,
854,
855,
856,
857,
858,
859,
860,
861,
862,
863,
864,
865,
866,
867,
868,
869,
870,
871,
872,
873,
874,
875,
876,
877,
878,
879,
880,
881,
882,
883,
884,
885,
886,
887,
888,
889,
890,
891,
892,
893,
894,
895,
896,
897,
898,
899,
900,
901,
902,
903,
904,
905,
906,
907,
908,
909,
910,
911,
912,
913,
914,
915,
916,
917,
918,
919,
920,
921,
922,
923,
924,
925,
926,
927,
928,
929,
930,
931,
932,
933,
934,
935,
936,
937,
938,
939,
940,
941,
942,
943,
944,
945,
946,
947,
948,
949,
950,
951,
952,
953,
954,
955,
956,
957,
958,
959,
960,
961,
962,
963,
964,
965,
966,
967,
968,
969,
970,
971,
972,
973,
974,
975,
976,
977,
978,
979,
980,
981,
982,
983,
984,
985,
986,
987,
988,
989,
990,
991,
992,
993,
994,
995,
996,
997,
998,
999,
1000) BULK COLLECT INTO var_typ
FROM dual;
END;