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