Saturday, September 29, 2007

Renaming a column

During class, Dan found this reference on renaming a column:
http://www.dba-oracle.com/t_rename_column_table.htm
Version 9i was the first to allow this - prior to that you had to work around.
SQL> alter table first rename column stadr to streetadr;

No comments: