Re: rename a column

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 09 Feb 2001 00:12:44 -0800
Message-ID: <3A83A67C.417E0B84@exesolutions.com>

> 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 Received on Fri Feb 09 2001 - 02:12:44 CST