--那么,这么写 scott@ORA11GR2> select lpad('1', 3, '0') from dual;LPA --- 001
select lpad(barcode, 3, '0') from 表名;
WITH TEST AS ( SELECT '2' AS ID,'AA' AS NAME FROM DUAL UNION SELECT '1' AS ID,'BB' AS NAME FROM DUAL UNION SELECT '22' AS ID,'CC' AS NAME FROM DUAL )SELECT LPAD(ID,3,0) FROM TEST
select to_char(barcode, '099') from 表名;
前面我说错了 本来就是 VARCHAR2(50)型的
只是要在前面加0
scott@ORA11GR2> select lpad('1', 3, '0') from dual;LPA
---
001
SELECT '2' AS ID,'AA' AS NAME FROM DUAL
UNION
SELECT '1' AS ID,'BB' AS NAME FROM DUAL
UNION
SELECT '22' AS ID,'CC' AS NAME FROM DUAL
)SELECT LPAD(ID,3,0) FROM TEST