oracle中将两列合并然后查询

select en_route_rte_id as id,txt_loc_desig||routelevel as name from en_route_rte e  order by e.txt_loc_desig