oracle sql

1、字段值相加，以“,”相连

select wm_concat(username)   from  user

2、特殊排序

  order by   
  case when t5.knowledgeuuid = ?  then 0  
   else 1  
  end ,  
   t5.optime desc