OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » change column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

change column [message #365137]

Fri, 07 April 2000 06:11

jelena Djuric
Messages: 2
Registered: April 2000

Junior Member

How can I change the name of the column?

Thanks,Jelena

Report message to a moderator

Re: change column [message #365151 is a reply to message #365137]

Wed, 12 April 2000 08:22

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

Report message to a moderator

Re: change column [message #365152 is a reply to message #365137]

Wed, 12 April 2000 09:54

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

Report message to a moderator

Previous Topic:	Formatting a date
Next Topic:	Convert number to string

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 06:39:05 CST 2025