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

Hi Frank -used to ask myself the same question. Then I transferred an Access (cough!) database to Oracle, and discovered an excellent reason why it would be nice to rename columns -the case-sensitivity issue. I am older and wiser now, of course, but still choke on having to remember to uppercase everything in Access.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"frank" <fbortel_at_home.nl> wrote in message news:39F9B600.6EE9A075_at_home.nl...


> No, but adding a new and dropping the old would

> result in the same. Why change the name of

> a column anyway?

>

> Francesco Marchioni wrote:

>

> > 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

> > >

>