Profile Picture
IT Made Easy
The site provides some rough IT Notes that make your life easier. The site currently has notes on HTML, CSS, Regex, OOPS, JS, JQuery, PHP, Java, ASP.NET, C#, Database, Linux, URL Rewrite, SEO, Project Management and Hosting. Please do share this site if you like.


View is nothing but parsed SQL statement which fetches record at the time of execution.

There are mainly two types of views

  1. Simple View
  2. Complex View


  1. Updatable Views
  2. Read only Views.

Finally we have Materialized Views.

View is used for the purposes as stated below:

  1. Security
  2. Faster Response
  3. Complex Query solve

Syntax is:

CREATE or REPLACE view ([olumn1] [column2]...)


SELECT column1 column2...

FROM tablename

[WHERE condition]

[WITH read only] [WITH check option]

IT Notes

by VinodSebastian

IT Downloads