Re: OT RE: Renaming columns ...

Maybe I'll just set up a perl script to send this to the list at random times, save everyone some KB time.

Jared

On Monday 04 June 2001 13:44, Mohan, Ross wrote:
> ARE YOU AN IDIOT
>
> || -----Original Message-----
> || From: Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com]
> || Sent: Monday, June 04, 2001 4:17 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: Renaming columns ...
> ||
> ||
> || HELP !
> ||
> || > -----Original Message-----
> || > From: PHU,JULIA (HP-Sunnyvale,ex2) [SMTP:julia_phu_at_hp.com]
> || > Sent: Monday, June 04, 2001 2:21 PM
> || > To: Multiple recipients of list ORACLE-L
> || > Subject: RE: Renaming columns ...
> || >
> || > ALTER TABLE table_name MODIFY ( new_col_name DATATYPE);
> || >
> || > It works for me in 8i.
> || >
> || >
> || >
> || > -----Original Message-----
> || > Sent: Monday, June 04, 2001 11:27 AM
> || > To: Multiple recipients of list ORACLE-L
> || >
> || >
> || > Chris:
> || >
> || > I've been browzing the on-line docs for 9i and the release
> ||
> || notes and have
> ||
> || > seen nothing about renaming a column...can you point me to
> ||
> || the location in
> ||
> || > the docs that give the syntax?
> || >
> || > Thanks
> || > Kevin
> || >
> || > -----Original Message-----
> || > Sent: Monday, June 04, 2001 1:17 PM
> || > To: Multiple recipients of list ORACLE-L
> || >
> || >
> || > Yes renaming a column is supported, in fact you can change
> ||
> || almost every
> ||
> || > aspect of a table online.
> || > it works parallel to existing table, right before
> ||
> || switching them over, it
> ||
> || > gets the latest DML applied, then switches over.
> || >
> || >
> || > "Walking on water and developing software from a
> ||
> || specification are easy if
> ||
> || > both are frozen."
> || >
> || > Christopher R. Spence
> || > Oracle DBA
> || > Fuelspot
> ||
> || --
> || Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || --
> || Author: Deshpande, Kirti
> || INET: kirti.deshpande_at_verizon.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: Jared Still
  INET: jkstill_at_cybcon.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).