求一sql

SQL> select * from a;ID
----------------------------------------
0210000000
2100000000
0218000000SQL> 
SQL> SELECT DECODE(MOD(LENGTH(RTRIM(ID, '0')), 2),
  2                0,
  3                RTRIM(ID, '0'),
  4                RTRIM(ID, '0') || '0'),
  5         ID
  6    FROM A;DECODE(MOD(LENGTH(RTRIM(ID,'0'            ID
----------------------------------------- ----------------------------------------
0210                                      0210000000
21                                        2100000000
0218                                      0218000000SQL>