SQL> desc emp; 名称 是否为空? 类型 ----------------------------------------------------- -------- ------------------ EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) COMM NUMBER(7,2) DEPTNO NUMBER(2)SQL> select ename from emp order by ename;ENAME ---------- ADAMS ALLEN BLAKE CLARK FORD JAMES JONES KING MARTIN MILLER SCOTT SMITH TURNER WARD已选择14行。已用时间: 00: 00: 00.01 SQL>
哦,可能这样才是你的意思吧 SQL> select to_number(sal) sal1 from emp order by sal1; SAL1 --------- 1600 1900 2200 2500 2500 2600 3000 3200 4900 5700 5950 6000 6000 10000已选择14行。已用时间: 00: 00: 00.00 SQL>
应该是这样吧,首先应该把id 转换成数字再进行排序!!! select * from table order by to_number(id)
直接用 select * from emp order by to_number(id); 能出你要的结果吧
名称 是否为空? 类型
----------------------------------------------------- -------- ------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)SQL> select ename from emp order by ename;ENAME
----------
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH
TURNER
WARD已选择14行。已用时间: 00: 00: 00.01
SQL>
SQL> select to_number(sal) sal1 from emp order by sal1; SAL1
---------
1600
1900
2200
2500
2500
2600
3000
3200
4900
5700
5950
6000
6000
10000已选择14行。已用时间: 00: 00: 00.00
SQL>
应该是这样吧,首先应该把id 转换成数字再进行排序!!!
select * from table order by to_number(id)
select * from emp order by to_number(id);
能出你要的结果吧