create table ant as select CARDINDEXfrom t_eb_cardinf;
alter table ant add (aindex number(10));
update ant set aindex=CARDINDEX;
select CARDINDEX from ant order by aindex asc;
drop table ant;
方法2:
select CARDINDEX from t_eb_cardinf where CARDINDEX9 and CARDINDEX99 and CARDINDEX999 and CARDINDEX select * from t order by length(a);
A
----------
9
4
111
222
333
SQL> select a from t
2order by length(a),a;
A
----------
4
9
111
222
333
-----------------这应该是你要的吧(如果有0.0011小数又有新的问题)
如果都是数字就用TO_NUMBER吧
SQL> DESC T;
名称
是否为空? 类型
----------------------------------------- -------- ----------------------------
A
CHAR(10)
SQL> ALTER TABLE T MODIFY A VARCHAR(11);
表已更改。
SQL> UPDATE T SET A=TRIM(A);
已更新 1 行。