Re: Change columns datatype and order

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 27 Jun 2005 19:16:08 +0200
Message-ID: <d9pbu9$keg$1@news6.zwoll1.ov.home.nl>

DA Morgan wrote:
> Ach C via DBMonster.com wrote:
>

>> Hi all,
>>  In fact I have two questions! :D 1.How to change a columns data type
>> without making that column empty? 

>
>
> Depends on what change you are trying to do and what version of Oracle
> something you seem to think unimportant.
>
> Generally speaking no problem with:
>
> CREATE TABLE t (
> mycol VARCHAR2(30));
>
> ALTER TABLE t MODIFY (mycol VARCHAR(100));
>

That's not even a different *data type*. And why do you insist on using VARCHAR? :devil: ;)

-- 
Regards,
Frank van Bortel

Received on Mon Jun 27 2005 - 12:16:08 CDT