Re: Does ORACLE has any stupid restrictions like MS-SQL

No Igor,

Stephane is right - you cannot CHANGE a datatype - but you can extent it. Meaning you can extent NUMBER(5) to NUMBER(10), VARCHAR2(10) to VARCHAR2(50). But you can NEVER decrease either.

To make any converstion you must create a copy of the table using create table as select, rename/drop the old, rename the new, and voila.

-- 
// Complete Data Service
// Peter H. Larsen
// petlars_at_pip.dknet.dk

Igor Chernysh <igor_at_ios.com> skrev i artiklen <33373E6E.2186_at_ios.com>...


> > Stephane Lajeunesse wrote:

> > 

> > If I remember correctly, this is defined in the ANSI standard for SQL

> > and is also true for Oracle (cannot drop a column, or chage it's

> > datatype).

> 

> The lastest is possible:

> 	alter table employee modify last_name varchar2(2000);

> WBW, Igor.

>