From: "Steve Long" <steven.long@erols.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: newbie question on sql
Date: Sun, 15 Apr 2001 08:11:37 -0400
Lines: 11
Message-ID: <9bc3aj$mhg$1@bob.news.rcn.net>
References: <20010415.181554.846811127.4449@localhost.localdomain>
X-Trace: UmFuZG9tSVaZSNogzwq0XtCzEQ7yjfZQjXu84rRDDwJRXErGp/yeVrkeHb6bKdgjxiJyFGhZ1p0=
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 15 Apr 2001 12:14:11 GMT
X-MimeOLE:  Produced By Microsoft MimeOLE V5.50.4133.2400
X-Priority:  3
X-Newsreader:  Microsoft Outlook Express 5.50.4133.2400
X-MSMail-Priority:  Normal


you can create a new table with the desired column names and then move/copy
the rows into the new tale, then drop the old table.

"webbug" <NOSPAMbandlover@hotmail.com> wrote in message
news:20010415.181554.846811127.4449@localhost.localdomain...
> hello all,
> is it possible to rename a column of a table?
> if not, any other alternatives?
> thanks