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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Changing datatype of a databasefield

Re: Changing datatype of a databasefield

From: Frank <franjoe_at_frisurf.no>
Date: Fri, 27 Apr 2001 17:14:45 +0200
Message-ID: <02gG6.1105$Ty6.15687@news1.oke.nextra.no>

>
> Alter table TabelToAffect Alter FieldToAffect varchar(50) null

Hi!

Yes it is possible to do this:
ALTER TABLE TabelToAffect MODIFY FieldToAffect VARCHAR(50) NULL;

Frank Received on Fri Apr 27 2001 - 10:14:45 CDT

Original text of this message

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