Oracle PL/SQL

Wednesday, August 23, 2006

How to append '0' to single Digit Numbers

DROP TABLE AX;

CREATE TABLE AX ( COL NUMBER );

INSERT INTO AX ( SELECT ROWNUM FROM ALL_OBJECTS WHERE ROWNUM < 11 );

SELECT TO_CHAR(COL,'00') FROM AX;

TO_
---
01
02
03
04
05
06
07
08
09
10

9 rows selected.

SQL> SELECT TO_NUMBER(TO_CHAR(COL,'00')) NUM FROM AX;

NUM
----------
1
2
3
4
5
6
7
8
9

9 rows selected.

0 Comments:

Post a Comment

<< Home