日期:2014-05-17 浏览次数:20784 次
CREATE TABLE T84 ( ID NUMBER(4), flarea VARCHAR2(20) ); INSERT INTO T84 VALUES(1, '139.00'); INSERT INTO T84 VALUES(2, '148.00'); INSERT INTO T84 VALUES(3, '133.00'); INSERT INTO T84 VALUES(4, '其它'); INSERT INTO T84 VALUES(5, '122.00'); INSERT INTO T84 VALUES(6, '平方米'); INSERT INTO T84 VALUES(7, '其它'); INSERT INTO T84 VALUES(8, '平方');
------解决方案--------------------
先to_number(),再to_char() 看他们的length
------解决方案--------------------