title: Passing the tablename to the cursor
body: <p>Guys is it possible to pass the table name from one cursor to another. kindly let me the other way.</p>
  
  <pre><code>CURSOR  R IS SELECT TABLE_NAME FROM RESOURCE ;
  
  
  CURSOR S(TAB VARCHAR2) IS SELECT  username from TAB where sid=1291;
  </code></pre>
  
  <p>is there another way to pass the table to a cursor.</p>