title: how to store resultset in type and fetch in Oracle
body: <p>I am new for Oracle.I just want to capture the result of the selection in variable and then I want to use that variable for multiple operation on that data like we do in the Sql server using table variable.</p>
  
  <p>I tried as below:</p>
  
  <pre><code>BEGIN
     DECLARE
        TYPE FullRecord IS RECORD (RNumber NUMBER);
        rec    FullRecord;
     BEGIN
        SELECT RNumber 
         INTO rec 
        FROM tableData;
     END;
  
  END
  </code></pre>
  
  <p>;</p>