Re: Need Help with SQL Plus in 8i

I would convert and store it as a qblob2 during the processing of the fourth presentation layer (my preferred option) rather than reading about format possibilities and/or string manipulation functions in the Oracle docs.

any available DBA jobs at Oracle -:)
Keld.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3c691464$0$225$ed9e5944_at_reading.news.pipex.net...
> Either store it in a varchar2 column of the appropriate length (my
preferred
> option) or else do the conversion in the presentation layer. numbers are
> numbers are numbers and do not have fancy formatting. interfaces have
> formatting.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Sergiu gp" <sergiugp_at_aol.com> wrote in message
> news:20020210135415.02129.00000809_at_mb-ch.aol.com...
> > Hello guys, I am trying to perform a query on a table where there is a
> 'phone'
> > column that has datatype char. I must convert it into a number and
format
> it as
> > follows: '(999) 999-9999' . I can't seem to find a way to do this
> correctly. I
> > am using the command TO_NUMBER(phone, '(999) 999-9999'). I keep getting
an
> > illegal number format error. Can someone help?
> >
> > Thanks a bunch!
>
>
Received on Tue Feb 12 2002 - 21:49:23 CET