Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rename col
Hi,
I'm not aware of a way to rename a column as you request, but to rename a table
you simply use:
RENAME oldname TO newname;
Hth,
Steve
rcn wrote:
> is there a way to rename a col without having to add the new col, copy data
> to it and drop the old col? Oracle 8.1.6.
>
> how about renaming a table?
Received on Wed Apr 04 2001 - 12:07:07 CDT