Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

analytic sql question

715939Aug 6 2009 — edited Aug 11 2009
Dear All,
I have the following problem of getting the output table from the input table below.
Do you have any idea of doing this with the help of analytic sql?
p.s. I have done this by using pure plsql block which is too slow to run with high amount of data. Below data is just a sample, in real I have millions rows of data.

Input table:
TIME USER VALUE

1 A X
2 A X
3 B Y
4 B Y
5 A X
5 B X
6 A Y
7 B Y
7 A Y



Output table:
START_TIME END_TIME USER VALUE
1 2 A X
5 5 A X
6 7 A Y
3 4 B Y
5 5 B X
7 7 B Y
This post has been answered by Aketi Jyuuzou on Aug 6 2009
Jump to Answer

Comments

It seems like issue with event scope, your button may not be part of the same region as LOV and report.

John Snyders-Oracle

The apexafterclosedialog is an APEX specific event that is triggered when any APEX modal dialog page closes (not cancels). This typically means when it is closed from an Apply or OK button.
The element in the parent page that the event is triggered on depends on what opened the dialog. That is why I prefer to listen for apexafterclosedialog on the body (or in some cases you need to listen on document).
To refresh a region or item you can use the built-in action Refresh. This is better than using apex.event.trigger(jQuery id, 'apexrefresh').

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 8 2009
Added on Aug 6 2009
27 comments
15,339 views