ALTER TABLE ..... RENAME ..... TO ..... does not work ?
When I enter the following command in SQLplus it is accepted (and executed ?) without problems.
ALTER TABLE tablesum
RENAME currency TO curr;
However when I enter afterwards a
SELECT * FROM tablesum;
then as header of the column appears still "currency"
Does RENAME only affect the column name and NOT its header ?
If yes how can I change both column name and header together ?
Yes, I have done a COMMIT;