5 Replies Latest reply: Jun 28, 2012 3:07 AM by BluShadow RSS

    cursor in select query in row to column format

    vishnu prakash

      I have the query like below
      SELECT d.department_id, 
                   CURSOR(SELECT e.first_name, 
                    FROM   employees e
                    WHERE  e.department_id = d.department_id
             ) emps
      FROM   depatments d
      I want the result set in a format of Row To columns like
      10                             20
      <cursor result>   <cursor result>
      pls give ur suggestions how to achieve this in a efficient way?I tried the method of "max(decode(.." but dont think so its possible with this