Oracle和MySQL中区别

函数: to_char(wm_concat(C.CNAME))和GROUP_CONCAT(C.CNAME)

select A.SNAME, to_char(wm_concat(C.CNAME))
  from student A
  join sc B
    on A.SNO = B.SNO
  join course C
    on B.CNO = C.CNO
 group by A.SNAME;

select A.SNAME, GROUP_CONCAT(C.CNAME)
  from student A
  join sc B
    on A.SNO = B.SNO
  join course C
    on B.CNO = C.CNO
 group by A.SNAME;