Home » SQL & PL/SQL » SQL & PL/SQL » Alter column
Alter column [message #237320] Mon, 14 May 2007 02:58 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member
Hi,

my oracle version is 9i.

My table structure

emp:

create table emp(No number,name varchar2(20));

table created.

now i want to change a column name as ename .

what can i do. Am new in oracle

Please help me..


Arun..

Report message to a moderator

Re: Alter column [message #237322 is a reply to message #237320] Mon, 14 May 2007 03:00 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Is this a school assignment or are they interview questions?

Report message to a moderator

Re: Alter column [message #237326 is a reply to message #237322] Mon, 14 May 2007 03:02 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

i wnat answer..

Report message to a moderator

Re: Alter column [message #237327 is a reply to message #237320] Mon, 14 May 2007 03:03 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I could tell you to check out the documentation, but hey, here goes:

alter table yourtable RENAME COLUMN name to ename
/


I doubt whether it works in 9iR1 though.

MHE

Report message to a moderator

Re: Alter column [message #237335 is a reply to message #237326] Mon, 14 May 2007 03:30 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
rleishman wrote on Mon, 14 May 2007 10:00
Is this a school assignment or are they interview questions?
akkumar81 wrote on Mon, 14 May 2007 10:02

i wnat answer..



Ross, how DARE you ask such questions. If you have no answer, don't bother to post!
It's clear the OP wnats answer!!!

Report message to a moderator

Re: Alter column [message #237424 is a reply to message #237320] Mon, 14 May 2007 08:00 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Homework answers should not be spoon fed. The user has to show what they have tried, otherwise they will never learn. I wouldn't have asked if this was homework, I would have stated this was homework and told them to show me what they have already tried.

Report message to a moderator

Re: Alter column [message #237428 is a reply to message #237424] Mon, 14 May 2007 08:17 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
But the lazy SOB who asked the question has shown time and time again that they are lazy, have poor communication skills, no ability to find an answer even given links to the documentation and have no hope whatsoever of getting a job.
When they go on a real interview, maybe they can ask the interviewer if they can ask someone else for the answer because that's how they have always done it in the past. Sounds like the kind of person I would love to be working with.

Makes you wonder what their 2 years of experience is in. Cheating?

[Updated on: Mon, 14 May 2007 08:19]

Report message to a moderator

Previous Topic: how to give hint in view
Next Topic: identity column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 20:51:03 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.