Re: Inserting '-' in place of blanks in a column

"Erwin" <erwincisco_at_yahoo.com.sg> schrieb im Newsbeitrag news:4WDya.1202$Ac3.13956_at_news-server.bigpond.net.au...
> Hi,
>
> Is it possible to insert the symbol '-' in the column where the value of
 the
> field is NULL and the field datatype is integer?
> I have tried using rpad and to_number function but it does not work.
>
> Thanks
>

Hi,

no, not possible. The minus is a character and has to be stored in e.g. VARCHAR2... columns.

hth and hand,
Guido Received on Wed May 21 2003 - 07:38:03 CEST