Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Multiple datasets in one dataset
Hi Brian,
sorry, that I did not answer your previous post completely. Your assumption (5a ... 5f) were all right.
The data gets be collected correctly.
After excessive testing I found out, that Oracle ends up in an endless loop when executing your fabulous statement with data where CURR_MS and all other VALUE_N are filled with 0.
Maybe you could test it with the following sample data:
REM INSERTING into FOO
Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,0,0,0,0,0,0,0,0,0,0,0);
Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,0,0,0,0,0,0,0,0,0,0,0);
Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,0,0,0,0,0,0,0,0,0,0,0);
Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,0,0,0,0,0,0,0,0,0,0,0);
Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,0,0,0,0,0,0,0,0,0,0,0);
Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,0,0,0,0,0,0,0,0,0,0,0);
Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',26,0,0,0,0,0,0,0,0,0,0,0);
I think we should be aware of such 0 values. What do you think?
Regards
Roman
Received on Wed Oct 17 2007 - 08:36:47 CDT
![]() |
![]() |