oracle 将两列合并

select  nvl(PROGROUPNUM,'空')||PROGROUPNAME   as AB from Tal_Profession_Group

 

 

 

用||