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

posted @ 2013-02-21 09:38  忆如梨花  阅读(1170)  评论(0编辑  收藏  举报