title: Join a cursor or record set in oracle
body: <p>I have good experience in sybase and have started looking into oracle in free time.
  Most of the sybase procedures that i have worked with have temp tables and it makes sense to join two or more temp tables get a result set.</p>
  
  <p><strong>Question:
  Is there a way to join two or more cursors like a logical table.</strong></p>
  
  <p>Something like:</p>
  
  <pre><code>SELECT c1.id, 
         c2.name 
    FROM cursorEmp c1, 
         CursorDept c2 
   WHERE c1.DeptId = c2.DeptId
  </code></pre>