This discussion is archived
5 Replies Latest reply: Jun 28, 2012 1:07 AM by BluShadow RSS

cursor in select query in row to column format

703441 Newbie
Currently Being Moderated
Hi

I have the query like below
SELECT d.department_id, 
             CURSOR(SELECT e.first_name, 
                     e.last_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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points