Untitled

Create table Workernew(Empno number(10),Ename varchar(10),job varchar(10),Mgr number(10),Sal number(10))
Desc Workernew
alter table Workernew add commission varchar(30)
alter table Workernew rename column job to designation
alter table Workernew drop column commission
insert into Workernew values(231,'John','Janitor',1002,5000)
insert into Workernew values(592,'Casey','recep',1006,8000)
insert into Workernew values(726,'Sebastian','accountant',1005,15000)
insert into Workernew values(236,'Lucifer','Manager',1001,25000)
insert into Workernew values(589,'Summer','Guard',1009,7000)
select * from Workernew