Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> to_char and format masks
Each,
SELECT 'ABC'||to_char(01234567, '09999999') FROM DUAL;
Returns
ABC 01234567 Why does this insert a blank between the ABC and formatted number?
Thanks Received on Tue Dec 06 2005 - 08:49:42 CST
![]() |
![]() |