This content has been marked as final. Show 3 replies
You Use CTAS then truncate your table rename the column.
You can change column name with follows.
This will not affect data, but you re-compile your PL/SQL if you use..
alter table sales rename column col4 to col3;
Thanks a lot asahide, it works now,
Thanks Osama for your reply.