title: How to add array in existing oracle sql cursor
body: <p>I am dealing with more than 25 tables which having association and I need to return a simple array/cursor from my stored procedure.<br>
  To make simple my question I am providing below example:-   </p>
  
  <p>For mentioned below scenario I want to add subjects against each student means in existing emp_curr I want to add result of sub_cur.</p>
  
  <pre><code>cursor emp_curr is
       select st_id,st_name,st_surname from student;
  BEGIN
       FOR n IN emp_curr LOOP
       DECLARE
            cursor sub_cur is
            select sub_id,subject from student_subjects where st_id_fk=n.st_id;
       BEGIN
             FOR c IN sub_cur LOOP
             -- Here I want to store sub_cur values in existing emp_curr 
            end loop;
         END;
       end loop;
  END;
  </code></pre>
  
  <p>Final Output<br>
  <code>
  |-----------|--------------|----------|---------------|-
  |Student ID | Student Name |Student ID|Student subject|
  |-----------|--------------|----------|---------------|-
  |   1       |  prashant    |    2     |    Maths      |
  |   1       |  prashant    |    4     |    English    |
  |   1       |  prashant    |    3     |    Science    |
  |-----------|--------------|----------|---------------|-
  |   2       |  shailndra   |    1     |    Hindi      |
  |   2       |  shailndra   |    5     |    Geo        |
  |   2       |  shailndra   |    7     |    Chemical   |
  |-----------|--------------|----------|---------------|-
  </code>
  It will be great if you can help me as I have already spent 4 hours and its gone in vain.</p>