Existing column of the table can be renamed?

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

Moderator: Tim...

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

Existing column of the table can be renamed?

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


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?


Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Existing column of the table can be renamed?

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


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.


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: https://oracle-base.com
My blog: https://oracle-base.com/blog

Return to “Oracle Certification”

Who is online

Users browsing this forum: No registered users and 1 guest