Home » SQL & PL/SQL » SQL & PL/SQL » how to change unused to used columns
how to change unused to used columns [message #209069] Wed, 13 December 2006 03:35 Go to next message
Messages: 65
Registered: November 2006
Location: Mumbai

Hi All,

Is ther any possibility to change unused column to used one

Re: how to change unused to used columns [message #209071 is a reply to message #209069] Wed, 13 December 2006 03:41 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you've set a column to unused by specifying SET UNUSED on the drop column command, then I'm afraid that the column and it's contents are gone, and there's no way to get it back other than to finishe dropping it (with ALTER TABLE....DROP UNUSED COLUMNS) and then add a new column with the same name.
Previous Topic: number to char conversion
Next Topic: how to handle this error: ORA-00988 ???
Goto Forum:

Current Time: Wed Oct 26 14:13:50 CDT 2016

Total time taken to generate the page: 0.07126 seconds