Re: Renaming columns?

From: Carlos Netto <Carlos.Netto_at_ibase.org.br>
Date: Sat, 20 Aug 94 22:33:00 -0300
Message-ID: <2aa.720.846%mpcbbs_at_ibase.org.br>

On 17 Aug 94 05:56pm, Howard Hartsfield wrote to ALL:

 HH> Newsgroup: comp.databases.oracle
 HH> Organization: Tallahassee Free-Net

 HH> Is there a way to rename a column in Oracle?
 HH> -- 
 HH> Howard Hartsfield                                         
 HH> howardh_at_freenet.fsu.edu CMS/DATA, Inc                                   
 HH>               Voice:904-224-2200 

No. You can make the column NULL and create another column with the new name. The older column will be unused until next database reorg.

If your follow good programming style (no select *, no inserts with no column specification, etc), an unused column is no problem. If not, you can rename the table to old_table and create a view with the same name of the original table, selection only the valid columns. It's safer if you have no 100% control of every SQL statement (99% of the cases).

Good luck,

---

| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |

|---------------------------------------------------------------------------|


|  Softex 2000 member           | Brazil, Sao Paulo state, Campinas city    | 


=============================================================================

• Evaluation copy of Silver Xpress. Day # 57 --- via Silver Xpress V4.01P [NR]

  ---

User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.

---

Received on Sun Aug 21 1994 - 03:33:00 CEST