Re: Simple SQL question

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 1 Feb 2006 15:50:33 -0500
Message-ID: <6fSdnTeGKt2GgnzeRVn-hg@comcast.com>

"Muraleedharan" <Muraleerajan_at_gmail.com> wrote in message news:1138826128.935266.211190_at_g47g2000cwa.googlegroups.com...
> Do you know extra spaces will be suppressed
> by the fm command in Oracle ?
>

fm is not a command, it is a format mask element, used in to_char when formatting a number or a date to a varchar2

SQL> select to_char('extra spaces', 'fm') from dual; select to_char('extra spaces', 'fm') from dual

*
ERROR at line 1:
ORA-01722: invalid number

unless you've got a working example...

++ mcs Received on Wed Feb 01 2006 - 14:50:33 CST