DBMS queries

DBMS queries,22319 DBMS queries,MSBTE,DIPLOMA DBMS queries,MSBTE DBMS queries

 

  DBMS  QUERIES


create table sy(id int,name varchar(50));

 

 

insert into sy values(1,'sonu');

 

 

insert into sy values(2,'monu');

 

 

insert into sy values(3,'aman');

 

 

 

insert into sy values(4,'geeta');

 

 

 

select * from sy;

 

 

 

create view syco as select id,name from sy;

 

 

select * from syco;

 

 

create table student(s_id int,s_name varchar(20),s_surname varchar(20));

 

 

insert into student values(1,'akash','kale');

 

 

 

insert into student values(1,'pranit','bhalerao');

 

 

 

insert into student values(1,'meena','wagh');

 

 

 

create view stview as select s_id,s_name from student;

 

 

 

select * from stview;

 

 

 

create view stview1 as select s_id,s_name,s_surname from student;

 

 

 

select *from stview1;

 

 

 

drop view stview;

 

 

 

insert into stview1 values (4,'neeta','dole');

 

 

 

select * from stview1;

 

 

 

delete from stview1 where s_id=4;

 

 

 

select * from stview1;

 

 

 

select *from syco, stview1;

I am Vishal Chavare , I'm a coder, animater. I'm extremely fond of anything related to education, animation & coding. I aim to reach my creative goals one step at a time I believe everyth…

Post a Comment

Solved Manual

© Computer Diploma Third Semester. All rights reserved. DMCA.com Protection Status