Mini-tip #1 - Getting rid of spaces after TO_CHAR

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:

select to_char(1234.89, '$999,990.00') num_format
from dual

select to_char(SYSDATE, 'Day, Month DD, YYYY') date_format
from dual
I get:

1 row selected.

Friday , August 14, 2006

1 row selected.
Do you notice the lead spacing in the first statement and the odd spacing in the second?

Read the rest of this post

Editor's Picks

Free Newsletters, In your Inbox