View

The Most Important part of View is its Syntax. And understanding its component.

Syntax:

CREATE OR REPLACE VIEW view [FORCE|NOFORCE*][(alices[,alice],…)]

AS sub query

[WITH CHECK OPTION[CONSTRAINT constraint name]]

[WITH READ ONLY [CONSTRAINT constraint name]]




[] : OPTIONAL
*:Default Parameter


The sub query that defines the view can’t contain order by clause However you can use order by to display view contents.

Use of views

• Data Independence.
• Complex queries easy.
• Restrict data access.
• · To present different view of same data.