SQL Select into Nested Table
633948May 21 2008 — edited May 22 2008Hi,
I would like to be able to store results of a query in the database. So far, I believe the best method is to store it as a nested table so that I may refer to it by criteria (e.g. date, name, etc.). I am somewhat new to Oracle and I'm not sure how to do this.
The query will always return the same columns, so that should make it easier for me. Also, I need to be able to query the data that is stored into an APEX report region.
Can someone tell me if this is the best method to do this? Also, is there a tutorial anywhere that explains how to do what I want?
Thanks in advance,
-David