oracle 两行数据合并成一行_oracle10g 多行数据合并为一行 | 学步园

场景:

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

语文 背唐诗

数学 练珠算

英语 打瞌睡

发送时将合为一条记录 .

如下:

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