- View is a database object which contains the logical representation of data.
- View can be created on the entire table or particular columns on a table or subset of table.
- If we apply any DML operations on view, the same operations automatically effected on corresponding base table and vice versa.
How to create view:
Create view <view-name> as select <col-1,col-2,—col-n> from <tab-name>
create view emp_view as select eno, ename from emp
// created view with name emp_view on emp table with two columns(eno, ename).
- View is invalid whenever table is dropped and change the structure of table.