This forum is currently locked. You can't register or post questions at this time. (read more)

Existing column of the table can be renamed?

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

Moderator: Tim...

momer79
Member
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

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

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

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


Return to “Oracle Certification”

Who is online

Users browsing this forum: No registered users and 2 guests

cron