Re: Can I rename Columns?

belonch_at_bcbso.com (Bart lonchar) writes:
>Newsgroups: comp.databases.oracle
>Path: news-test.ny.us.ibm.net!news-m01.ny.us.ibm.net!newsjunkie.ans.net!howland.reston.ans.net!tank.news.pipex.net!pipex!usenet.eel.ufl.edu!pacifier!rainrgnews0!psgrain!qiclab.scn.rain.com!bcbso.com!pony!server2!belonch
>From: belonch_at_bcbso.com (Bart lonchar)
>Subject: Can I rename Columns?
>Message-ID: <DF45sA.Hzo_at_pony.bcbso.com>
>Keywords: Oracle 7
>Sender: usenet_at_pony.bcbso.com (Usenet News Poster)
>Nntp-Posting-Host: server2-nf.bcbso.com
>Reply-To: belonch_at_bcbso.com
>Organization: Blue Cross Blue Shield Ore
>Date: Mon, 18 Sep 1995 18:24:10 GMT
>Lines: 3
>
>Is it possible in Oracle 7 to rename a column (on the catalog) once a table is defined? If so, how - and if not - why not?
>
>

If you want to rename a column, try this:

1. Rename the table
2. CREATE TABLE original_table_name AS (SELECT column1, column2, column3 new_column_name, column4 FROM renamed_name_table);

ENCTDEP_at_IBM.NET
ENNIA Caribe N.V.
Curacao Received on Wed Sep 27 1995 - 00:00:00 CET