oracle数据查询：多列合成一列

  --查询用户对应的角色，变将角色名称合并成一列显示
  --listagg(roles.name,'-')within  group  (order by users.id desc ) as roleName
  --group by users.id,users.realname,users.username
  select
    users.id,
    users.realname,
    users.username,
    listagg(roles.name,'-')within  group  (order by users.id desc ) as roleName
  from sys_users users
  inner join sys_users_roles usersRoles on users.id = usersRoles.User_Id
  inner join sys_roles roles on roles.id = usersRoles.role_id
  where 1=1  
  group by users.id,users.realname,users.username
  order by id desc;