create table employee (empid number(5),name varchar2(20),salary number(7),des varchar2(16));
insert into employee values(1001,'abi',20000,'manager');
insert into employee values(1002,'anu',40000,'hr');
insert into employee values(1003,'ammu',50000,'ass.manager');
select*from employee;
alter table employee add experience number(5);
update employee set experience=8 where empid=1001;
update employee set experience=7 where empid=1003;
select empid,name where salary>10000 and experience>5;