Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> zero filling a number
Why does select to_number(' 123',000999) from dual
return 123 rather than the expected 000123 ? since the is the suppose to be the purpose of the pattern ?
Troy. Received on Sat Sep 27 2003 - 20:50:46 CDT