create view V as select ename ||' '||deptno as data from emp; select data from V order by replace(data,replace( translate(data,'0123456789','##########'),'#',''),'') 上面代码,实现按照后面的数字排序。转化顺序是:clark10==>clark##==>clark==>10 下面给出按照前面字母排序的SQL代码:select data from V order by replace( translate(data,'0123456789','##########'),'#','') /