APEX

Hi,

This may not have a simple answer, I am new to Oracle and not familiar with all the options.....

I have created a PL/SQL report which generates some rather complex sql report. It changes a simple table i.e. revenue( period, customer, product, product_group, revenue_amt ) into a cross-tab report for presentation at the front end of my APEX app. I have a few LOVs that resubmit the page and regenerate the sql so you can choose a different customer or range of periods etc.

I am interested to know if there is a way in Oracle to generate a "Volatile Table" (this terminology is from my Teradata exp.) that I could hold this data in (for as long as the user does not change customers) and then query as the user makes changes to the way they want this information displayed. i.e. including totals per product group, hiding empty rows etc.

I can just keep expanding my PL/SQL, but it is starting to get unwieldy at 54 lines generating a page of SQL. If I could save the data into a table temporarily then abandon the table when no longer required it would help a lot.

I know I could create a normal table, but I would have to create one for every customer and the data changes so they would have to be regenerated. It would be more convenient to generate one per user session as required.

Your thoughts appreciated