select ID_NO, COURSE from COURSES
order by ID_NO
ID_NO Course
--------------
1 F101
1 D106
2 S105
2 C101
3 C101
3 A503
5 C102
I wanna see the result in below format through simple procedure, Help.
ID_NO Courses
-----------------
1 F101 D106
2 S105 C101
3 C101 A503
5 C102