Need Help with SQL Plus in 8i
From: Sergiu gp <sergiugp_at_aol.com>
Date: 10 Feb 2002 18:54:15 GMT
Message-ID: <20020210135415.02129.00000809_at_mb-ch.aol.com>
[Quoted] [Quoted] Hello guys, I am trying to perform a query on a table where there is a 'phone' [Quoted] [Quoted] column that has datatype char. I must convert it into a number and format it as [Quoted] [Quoted] follows: '(999) 999-9999' . I can't seem to find a way to do this correctly. I [Quoted] am using the command TO_NUMBER(phone, '(999) 999-9999'). I keep getting an [Quoted] [Quoted] illegal number format error. Can someone help?
Date: 10 Feb 2002 18:54:15 GMT
Message-ID: <20020210135415.02129.00000809_at_mb-ch.aol.com>
[Quoted] [Quoted] Hello guys, I am trying to perform a query on a table where there is a 'phone' [Quoted] [Quoted] column that has datatype char. I must convert it into a number and format it as [Quoted] [Quoted] follows: '(999) 999-9999' . I can't seem to find a way to do this correctly. I [Quoted] am using the command TO_NUMBER(phone, '(999) 999-9999'). I keep getting an [Quoted] [Quoted] illegal number format error. Can someone help?
Thanks a bunch! Received on Sun Feb 10 2002 - 19:54:15 CET