How to insert records into the RESULT of a query?
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?
Hope my description makes kind of sense.
Any help will be sincerely appreciated.