Thanx dear for quick reply.

This is a solution of that problem in 9i.

select
ID_NO,
sys.XMLTYPE.getCLOBval(
sys.XMLTYPE.extract(a.xml,'/ROWSET/ROW/COURSE_LIST/text()') ) "Courses"
from
(
select ID_NO, sys.XMLTYPE.createXML( xmlgen.getXML('select ID_NO,
COURSE||'' '' COURSE_LIST from COURSES where ID_NO = '||ID_NO||' order
by ID_NO') ) "XML" from COURSES group by ID_NO
) a

But I wanna handle this with the simple procedure.