Quote Originally Posted by PAVB View Post
...and the columns on your table are of the number datatype, init?

How about using decode()? like decode(t.month,1,'01',2,'02',...)
Looks kind on complex. Wouldn't LPAD work better?

Code:
SYS AS SYSDBA> select lpad('1', 2, '0') from dual;

LPAD('
------
01