Question

what is a view in a table?explain it's types.

Answer 1

1. View is nothing but parsed SQL statement which fetches record at the time of execution.2.There are mainly two type of viewsa) Simple Viewb) Complex Viewapart from that we can also subdivided views as UpdatableViews and Read only Views.Lastly there is an another view named as Materialized Views

.3. View is used for the purposes as stated below:

a) Securityb) Faster Responsec) Complex Query solve4.Syntax is :Create or replace view([olumn1],[column2]...)asSelect column1,column2...from table_name[where condition][with read only],[with check option]