WMSYS.WM_CONCAT排序

select max(a.var) from (
  select to_char(WMSYS.WM_CONCAT(t.id) over(order by t.id)) var --,t.name 
  from sys_role t where t.id not in
  (
  select t3.id--,t3.name
  from sys_role t3 join sys_role_authoritie t2 on t3.id=t2.role_id 
  where t2.authority_id=0 --order by t3.id
  ) 
) a