1)
Create view student.
Ø
create view student as select id,stud2.name,addr from stud1,stud2,stud3
with read only;
2)
Display view student.
Ø
select * from student;
3)
Create or replace the view student which has a where clause.
Ø
create or replace view student as select id,stud2.name,addr from
stud1,stud2,stud3 where stud1.id=stud2.enroll and stud2.enroll=stud3.enroll
with read only;
4)
Display view student.
Ø
select * from student;
5)
Insert, delete ad update view student.
Ø
insert into student values(1220,'avni','bilimora');
Ø
update student set name='avni' where id=1218;
Ø
delete student where id=1218
6)
Create updatable view student2 with only one table.
Ø
create view student2 as select enroll,name from stud3;
7)
Insert the view student2.
Ø
insert into student2 values(1220,'avni');
8)
Delete the view student2.
Ø
delete student2 where name='foram';
9)
Update the view student2.
Ø
update student2 set name='foram' where enroll=1220;
10)
Create updatable view from two table which are dependent.
Ø
create or replace view student as select id,stud2.name from stud1,stud2
where stud1.id=stud2.enroll;
11)
Insert, update and delete into view student.
Ø
insert into student values(1220,'avni');
Ø
update student set name='avni' where id=1218;
Ø
delete from student where id=1218;
12)
Create or replace view student2 with read only.
Ø
create or replace view student2 as select enroll,name from stud3 with
read only;
13)
Insert, delete and update view student.
Ø
insert into student2 values(1220,'avni');
Ø
update student2 set name='avni' where enroll=1218;
Ø
delete from student2 where enroll=1218;
14)
Create a view with two
in depended table with name student1.
Ø
create or replace view
student1 as select stud4.enroll,stud3.name from stud3,stud4;
15)
Insert, delete and
update the view student1.
Ø
insert into
student1values(1220,'avi');
Ø
delete from student1
where enroll='1218';
Ø
update student1 set
name='avi' where enroll='1218';
0 Comments