Existing column of the table can be renamed?

All posts relating to Oracle certification (OCA, OCP, OCM).

Moderator: Tim...

Existing column of the table can be renamed?

Postby momer79 » Thu Dec 24, 2009 11:30 am

Hi,

I am preparing for exam 1Z0-007 and according to sybex book
--------------------------------------------------------------
You cannot rename an existing column using the ALTER TABLE
statement. To rename the column, you must re-create the table with
the new name.
--------------------------------------------------------------

Well according to my experience its not true because i have tested it and it does work even if the column has no values.

Can anyone pls advise on it?

Thanks
momer79
Member
 
Posts: 22
Joined: Mon Oct 26, 2009 10:28 am

Re: Existing column of the table can be renamed?

Postby Tim... » Thu Dec 24, 2009 11:49 am

Hi.

Yes, you can rename a column. What you have to remember about this exam is it is extremely old. That is the same exam I did for my Oracle 7.3 certification. At that point it was not possible to rename a column.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Certification

Who is online

Users browsing this forum: No registered users and 2 guests