Today, I'm going to give you an Oracle tip to get rid of spaces after you've used TO_CHAR.
If I run this script:
I get:
select to_char(1234.89, '$999,990.00') num_format
from dual
/
select to_char(SYSDATE, 'Day, Month DD, YYYY') date_format
from dual
/
NUM_FORMATDo you notice the lead spacing in the first statement and the odd spacing in the second?
——————
$1,234.89
1 row selected.
DATE_FORMAT
——————————————-
Friday , August 14, 2006
1 row selected.
Read the rest of this post