SQL & PL/SQL

Hi all,

We have the following two tables:

SQL> select * from class;

  CLASS_ID     COURSE

---------- ----------

         1          1

         2          1

         3          1

         2          2

         3          2

         5          2

6 rows selected.

SQL> select * from course;

COURSE_ID

----------

         1

         2

The client requires the output in the following format:

course          class          class          class

1                    1               2               3

2                    2               3               5

I have considered the use of pivot tables however they require the use of an aggregate function, but there is no aggregation required in the result here - we just require the output to be displayed as would a pivot table?