Illustrate use of create view command and manipulating

 

SQL> create view EMP as
2 select *
3 from employee
4 where salary>14000;
View created.
SQL> select *
2 from EMP;
FNAME MINIT LNAME
-------------------- -------------------- ----------------
SSN BDATE ADDRESS SEX
-------------------- --------- -------------------- ------
SALARY SUPER_SSN DNO
---------- -------------------- ----------
Varun ganesh deva
0236 30-OCT-98 sediyapu puttur M
15000 1230 1
prjwal k raj
4126 13-DEC-93 jp nagara banglore M
14500 1240 2
FNAME MINIT LNAME
-------------------- -------------------- ----------------
SSN BDATE ADDRESS SEX
-------------------- --------- -------------------- ------
SALARY SUPER_SSN DNO
---------- -------------------- ----------
Thilak t naik
7894 30-AUG-96 beliyoorkatte puttur M
15000 1260 4