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

Home -> Community -> Usenet -> c.d.o.server -> Re: ** Manipulate Table **

Re: ** Manipulate Table **

From: <peter_at_hooiveld.demon.nl>
Date: Tue, 22 Jun 1999 20:57:34 GMT
Message-ID: <376ff7fb.3597292@news.demon.nl>


 On Tue, 22 Jun 1999 17:13:45 GMT, vmillan_at_dailyherald.com (Vic Millan) wrote:

>Hi,
>
>I need to a field in a table from 5 char to 10 chars.
>What is the best way of doing this?
>
>Vic
>vmillan_at_dailyherald.com
>

Making a column-definition 'wider' is easy:

alter table t modify ( c varchar2(10));

But making it smaller isn't!

Good luck,

Peter Received on Tue Jun 22 1999 - 15:57:34 CDT

Original text of this message

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