column [message #20398] |
Tue, 21 May 2002 01:06 |
Syed Zaki Hyder
Messages: 2 Registered: May 2002
|
Junior Member |
|
|
After droping the column name ,I want add same column name at same place,what is the qury
plz reply as soon as posbl
|
|
|
Re: column [message #20399 is a reply to message #20398] |
Tue, 21 May 2002 01:22 |
John R
Messages: 156 Registered: March 2000
|
Senior Member |
|
|
As far as I know, when you add a column it always goes at the end of the list of columns.
|
|
|
Re: column [message #20403 is a reply to message #20398] |
Tue, 21 May 2002 03:54 |
Tariq lakho
Messages: 3 Registered: May 2002
|
Junior Member |
|
|
You cann't add a column at specific postion.
You always add column at the end of the last column in the table
|
|
|
Re: column [message #20406 is a reply to message #20403] |
Tue, 21 May 2002 06:59 |
Su
Messages: 154 Registered: April 2002
|
Senior Member |
|
|
As others said, it is not possible to add a column at specific position in a table description/definition. The workaround is to use CREATE OR REPLACE TABLE command (available in all ORACLE 8.x versions) with same table description/definition and the new column you want. Try it out.
Good luck :)
|
|
|
Re: column [message #20461 is a reply to message #20403] |
Sat, 25 May 2002 14:24 |
Su
Messages: 154 Registered: April 2002
|
Senior Member |
|
|
I apologize, that CREATE OR REPLACE TABLE is not available in Oracle8i or above. There is another workaround, creating a tempo and renaming to the original, but there should be a better workaround.
Good luck:)
|
|
|