Home » SQL & PL/SQL » SQL & PL/SQL » change column
change column [message #365137] Fri, 07 April 2000 06:11 Go to next message
jelena Djuric
Messages: 2
Registered: April 2000
Junior Member
How can I change the name of the column?

Thanks,Jelena
Re: change column [message #365151 is a reply to message #365137] Wed, 12 April 2000 08:22 Go to previous messageGo to next message
santosh nayak
Messages: 1
Registered: April 2000
Junior Member
the only way to do this is to drop the column and again append it with the new name and insert the values again.(This feature supported only in Oracle 8i)

All the best
Re: change column [message #365152 is a reply to message #365137] Wed, 12 April 2000 09:54 Go to previous message
jelena Djuric
Messages: 2
Registered: April 2000
Junior Member
Thanks,but it is inpossibly to drop the column.
I have made a new table with a column I need and
insert a values again.

Sincerely,
Jelena Djuric
Previous Topic: Formatting a date
Next Topic: Convert number to string
Goto Forum:
  


Current Time: Thu Mar 28 08:42:02 CDT 2024