Oracle的分页与字符拼接

--    取出5~10行的数据
select *
  from (select e.*, rownum rn from emp e where rownum <=10)
 where rn > 5;
--    取出大于5的行的数据
 select *
  from (select e.*, rownum rn from emp e)
 where rn > 5;
--    拼接字符
select s.name, wmsys.wm_concat(c.name)
  from t_sc_deme sc, t_course_deme c, t_student_deme s
 where s.id = sc.stu_id
   and sc.course_id = c.id
 group by s.name