Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: R: [beginner] Changing column name and type without losing content
OK you got a point there.
I was thinking along the line of application; it
should/would make no difference to the application
(provided it was "standard case-sensitive")
-- Frank Howard J. Rogers <howardjr_at_www.com> schreef in berichtnieuws 39fca6f4$1_at_news.iprimus.com.au...Received on Mon Oct 30 2000 - 04:32:43 CST
> 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
> > > >
> >
>
>