oracle10g 多行数据合并为一行

场景:

发布家庭作业,多个科目,但实际通知只需要一条,存储时分科目存储,发送时合并为一条发送.如

语文 背唐诗

数学 练珠算

英语 打瞌睡

发送时将合为一条记录 .

查找资料,引用http://www.cnblogs.com/heekui/archive/2009/07/30/1535516.html

如下:

with a as
 (
  
  select course_name || description c_researcher_code,
          class n_sec_code,
          to_char(dateutil.int2date(end_date), 'DL') end_date,
          school
    from jxt_course, jxt_homework, jxt_class
   where course = jxt_course.id
     and jxt_class.id = class
     and start_date < dateutil.Now
     and end_date >= dateutil.get_day_part(dateutil.now) - 28800000
  
  )
SELECT n_sec_code class, wmsys.wm_concat(c_researcher_code) as message
  FROM a
 GROUP BY n_sec_code