title: How do I create and select from an in memory table in PL/SQL?
body: <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>