Existing column of the table can be renamed?

[momer79]

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...]

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...