Re: Need Help with SQL Plus in 8i
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 12 Feb 2002 13:10:52 -0000
Message-ID: <3c691464$0$225$ed9e5944_at_reading.news.pipex.net>
Date: Tue, 12 Feb 2002 13:10:52 -0000
Message-ID: <3c691464$0$225$ed9e5944_at_reading.news.pipex.net>
[Quoted] Either store it in a varchar2 column of the appropriate length (my preferred [Quoted] 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...Received on Tue Feb 12 2002 - 14:10:52 CET
> 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!