rename multiple columns [message #366183] |
Fri, 12 December 2008 00:31  |
panyam
Messages: 146 Registered: May 2008
|
Senior Member |
|
|
Hi ,
How to renmae multiple columns of a table in a single alter statement.
SQL> desc del;
Name Null? Type
----------------------------------------- -------- -------------
VAR1 NUMBER
VAR2 NUMBER
for a single column the following works.
SQL> ed
Wrote file afiedt.buf
1* alter table del rename column var1 to i
SQL> /
Table altered .
|
|
|
|
|
|
Re: rename multiple columns [message #366217 is a reply to message #366214] |
Fri, 12 December 2008 02:56  |
dr.s.raghunathan
Messages: 540 Registered: February 2008
|
Senior Member |
|
|
renaming multiple column at a stretch may be the need. But oracle supports one by one renaming. To my knowledge, upto 10G this facility is not available. Let me also wait for some updating.
yours
dr.s.raghunathan
|
|
|