title: Alternatives for temporary tables in Oracle
body: <ol>
  <li>Create a temporary table inside a stored procedure, say '#Temp'.</li>
  <li>Insert values into 'Temp' table using a select statement, eg. Insert Into #Temp Select * from Employees.</li>
  <li>Now extract data from this Temp table, eg. Select * from #Temp where #Temp.Id = @id &amp; so on.</li>
  </ol>
  
  <p>How to do this in <strong>Oracle inside a stored procedure</strong>?</p>