SQLize Online / PHPize Online  /  SQLtest Online

create table emp ( ename varchar(20), enumber number, ecity varchar(10) ); insert into emp values('utkarsh',9967070941,'dahisar'); insert into emp values('bhavesh',8989898989,'kandivali'); select *from emp; alter table emp add(country varchar2(20)); update emp SET country='INDIA' where ename='utkarsh'; select * from emp; alter table emp drop column country; select * from emp; alter table emp add(salary int); update emp SET salary=10000; select * from emp; alter table emp modify salary float; update emp SET salary=10000.25 where ename='bhavesh'; select * from emp; update emp SET enumber='' where ename='utkarsh'; select * from emp; delete from emp where ename='utkarsh'; select * from emp; insert into emp values ('devansh',9321541398,'malad',12000); insert into emp values ('dhanvi',12345567996,'andheri',14000); insert into emp values ('amit',1478523692,'kandivali',15000); select * from emp; select * from emp where ecity='kandivali'; create table emp1 as select * from emp; select * from emp; create view empview as select ename,ecity from emp; select * from empview; update emp SET ecity='' where ename='dhanvi'; select * from emp; create view empview2 as select ename,ecity from emp where ecity is not null; select * from empview2;