How do I create and select from an in memory table in PL/SQL?
<p>I'm using Oracle's PL/SQL and would like to create an in memory table from which I can do selects.</p>

<p>Let's say I have a table with only 20 records with two columns:
special_id(int), out_date(date)</p>

<p>I want to collect those 20 records and stick them in memory so I don't have to do the same select 10,000 times and I want to be able to access those 20 records later.</p>

<p>I then have a loop running a different query and I'd like to do the equivalent of the following inside that loop:</p>

<pre><code>select out_date 
from in_memory_table 
where in_memory_table.special_id = cursor.special_id (where cursor is from my current loop).
</code></pre>

<p>NOTE:  It makes no sense to loop through the in_mempry_table under ANY circumstance.  I just need to be able to access the data in that table.</p>

<p>I'm not including actual code here because I'd have to do a heck of a lot of work recoding so as to not give away company info.</p>