R: [beginner] Changing column name and type without losing content

From: Francesco Marchioni <Francesco.Marchioni_at_lastminutetour.com>
Date: Fri, 27 Oct 2000 09:44:03 +0200
Message-ID: <8tbbdr$3ud$1@marte.lastminutetour.com>

Hello,
thanks for your suggestion...anyway I needed one more step, that is changing column name too....is it possible to do it ? Thanks
Francesco

frank <fbortel_at_home.nl> wrote in message 39F87693.BB2966C5_at_home.nl...
> SQL> create table lazy( fr number(2));
>
> Table created.
>
> SQL> insert into lazy values(3);
>
> 1 row created.
>
> SQL> alter table lazy modify fr number(10);
>
> Table altered.
>
> SQL> desc lazy
> Name Null? Type
> ----------------------------------------- -------- ------------
>
> FR NUMBER(10)
>
> Guess why I called it lazy?
>
> Frank
> Francesco Marchioni wrote:
>
> > Hello,
> > I have a column in my DB which is a number(2). Now my doubt is:
> > Can I change column name & width ( to number (10) )
> > without having to drop the column and build a new one ?
> > In fact I'd like to save the data which is in the column.
> > Thanks
> > Francesco
>
Received on Fri Oct 27 2000 - 02:44:03 CDT