Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Does ORACLE has any stupid restrictions like MS-SQL

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

From: Igor Chernysh <igor_at_ios.com>
Date: 1997/03/24
Message-ID: <33373E6E.2186@ios.com>#1/1

Hi there,

> 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. Received on Mon Mar 24 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US