I also fully agree with Suarabh.JL if you know way
how to rename a column in 8i.Pls. share the syntax
with us.It will be great help to all of us.
Regards
Bipin
- Saurabh Sharma <saurabhs_at_fcsltd.com> wrote: > i
think u can't rename a column. it's still under
> consideration.
> if u can, pls mention with some more specific
> syntax.
>
> it'll b helpful for all.
> saurabh
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, February 14, 2001 12:50 PM
>
>
> > Wait wait wait...
> >
> > Yes you can rename a column in 8i, it just depends
> to what value your
> > compatibility parameter is set
> >
> > Regards
> > JL
> >
> > -----Original Message-----
> > Sent: Wednesday, February 14, 2001 8:05 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > In Oracle
> > It's not possible to rename a column.You can
> instead
> > use alias for that column name in your queries.
> > Or you have to create a new table from existing
> one
> > Drop existing table.And recreate a table by
> > selecting from new table.
> >
> > Regards
> > Bipin
> > --- Heikki Jantunen <hjantunen_at_hotmail.com> wrote:
> >
> > Hi all,
> > >
> > > I need to rename some columns on my table. Any
> idea
> > > how to do that...
> > >
> > > Thanks in advance,
> > >
> > > Hessu
> > >
> >
>
> > > Get Your Private, Free E-mail from MSN Hotmail
> at
> > > http://www.hotmail.com.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Heikki Jantunen
> > > INET: hjantunen_at_hotmail.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
> > > access / Mailing Lists
> > >
> >
>
> > > To REMOVE yourself from this mailing list, send
> an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be
> removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> >
>
> > Do You Yahoo!?
> > Get your free @yahoo.co.in address at
> http://mail.yahoo.co.in
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?bipin=20sahani?=
> > INET: bipinsahani_at_yahoo.co.in
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Johan Locke_at_i-Commerce Services
> > INET: Johan.Locke_at_za.didata.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Saurabh Sharma
> INET: saurabhs_at_fcsltd.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get your free @yahoo.co.in address at
http://mail.yahoo.co.in
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?bipin=20sahani?=
INET: bipinsahani_at_yahoo.co.in
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Feb 15 2001 - 01:27:19 CST
