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

You could, however, display them as "-" characters by using NVL, or by selecting via an unusual view on the table. (Unusual only in that you don;t normally change data types when using views.)

ETA "Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:<1053494970.962990_at_news.thyssen.com>...
> "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 - 10:52:00 CEST