Message-ID: <3ACB51FA.E0499BE2@sympatico.ca>
From: Steve Bell <swayne.bell@sympatico.ca>
X-Mailer: Mozilla 4.73 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: rename col
References: <9aa14f$t51$1@bob.news.rcn.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 16
Date: Wed, 04 Apr 2001 17:07:07 GMT
NNTP-Posting-Host: 199.243.226.66
X-Trace: news20.bellglobal.com 986404027 199.243.226.66 (Wed, 04 Apr 2001 13:07:07 EDT)
NNTP-Posting-Date: Wed, 04 Apr 2001 13:07:07 EDT
Organization: Sympatico


Hi,
I'm not aware of a way to rename a column as you request, but to rename a table
you simply use:

RENAME oldname TO newname;

Hth,
Steve

rcn wrote:

> is there a way to rename a col without having to add the new col, copy data
> to it and drop the old col?  Oracle 8.1.6.
>
> how about renaming a table?