Significance of OR REPLACE, FORCE and NOFORCE while creating view

Explain the significance of OR REPLACE, FORCE and NOFORCE while creating view.

The syntax for creating a view is:
CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view_name [alias[, alias]…)]
AS subquery
[WITH CHECK OPTION [CONSTRAINT constraint] ]
[WITH READ ONLY]

Subquery is SELECT statement (cannot contain the ORDER BY clause).

OR REPLACE is used to re-create the view if it already exists without having to drop it first.

FORCE creates the view regardless of whether or not the base table(s) exist.

NOFORCE creates the view only if the base tables exist.
List out advantages of Views
Using Views, user’s access to the entire content of table can be restricted by allowing accessing only Views with only required columns of the table.....
List out the guidelines to create a View
The view’s column names are same as the table’s column name. New column names has to be explicitly listed in the CREATE View......
What is synonym and how do we create synonym?
Table references can be complicated. So oracle allows you create synonym for a complicated reference. It renames a table reference......
Post your comment