how to rename and delete a particular column in a table?
Hi,
suppose i have a table having the following defination:
create table t1
( a number not null,
b varchar2(20),
c varchar2(20));
later on i want to rename column b to x and in the next step i want to delete column c and all its content. How to do that?