Re: rename a column

From: <rannerde_at_my-deja.com>
Date: Mon, 12 Feb 2001 14:17:07 GMT
Message-ID: <968r8s$18b$1@nnrp1.deja.com>

You are right!
But the guy who set up the tables called a column "Name" :o( And there are allready datas in this table... But I've found out, how it works - please see the threat.

Thank you,
Gerfried

In article <3A83A67C.417E0B84_at_exesolutions.com>, "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote:
> > How do I rename an existing column of a table with Oracle SQL?
>
> You can't ... yet. You will be able to, I believe, in version 9i due
out
> this Spring.
>
> But for now the best ways to accomplish that goal have been written by
> others. Though I've never understood why anyone would rename a table
> column. You can just change it by aliasing in your select statement.
For
> example
>
> SELECT user_first_name FNAME
> FROM users;
>
> will give a result for the user_first_name column as FNAME.
>
> Daniel A. Morgan
>
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Feb 12 2001 - 08:17:07 CST