I'll try to illustrate my problem with an example:
Say I have the following table:
I would like to query this table and to manipulate the result to look like
In short - I would like to identify breaks in contuous data (a number sequence in the example) and insert a record in the result set to indicate that there is a break. This is needed for a graphing component I use, to be able to draw discontinueties in a line graph.
I do not want to add this new record to my database, just pass it on to the application. How would I go about doing that?
My idea is to write a PL/SQL stores procedure to do the query, do the manipulation and then return the manipulated result set.
I am whoever not sure of which data structures to use -
I'll read the original query into a ? what ?
I can then loop through the records and figure out which records need to be added, add it and at the end of the loop return the ... errr ?what? ?how?