Can you rename a column?

[omegamark]

The answer is yes and no.

Yes means you can do in a round about manner like creating a view.

create table test (n number);
rename test to test123456789;

create view test (m) as select n from test123456789;

through view you can mask without really affecting the table or data's.

otherwise you have drop and recreate.

hope this helps