Re: Alter a char field

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 20 Mar 2007 08:03:14 -0700
Message-ID: <1174402993.458346@bubbleator.drizzle.com>

MattJ83 wrote:

>> Why do you use CHAR, and not VARCHAR2?
>> Why do you store a number in a character field?
>>
>> Sigh...
>> --
>> Regards,
>> Frank van Bortel

>
> Hi Frank,
>
> I was using the CHAR field because i had characters in the field....i
> wanted to get rid of these characters so that i could put the numbers
> in a NUMBER field

One has nothing to do with the other. Why are you using CHAR and not VARCHAR2?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Mar 20 2007 - 10:03:14 CDT