Re: Renaming a column
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 21 Jul 2001 21:51:22 GMT
Message-ID: <3B26F5B4.C9895C19_at_exesolutions.com>
Date: Sat, 21 Jul 2001 21:51:22 GMT
Message-ID: <3B26F5B4.C9895C19_at_exesolutions.com>
Ali Galewski wrote:
> How do you rename a column in a table?
In any version before 9i you don't.
You have two choices.
- alias the column name in your select statement as in
SELECT badname GOODNAME
FROM sometable;
or
2. Recreate the table from scratch.
If you have 9i I understand it can be done but I've not yet received my CD or learned the syntax.
Daniel A. Morgan Received on Sat Jul 21 2001 - 23:51:22 CEST