Views
CHAPTER 2-VIEWs à View can be defined to store select statements it will not find data or store data by itself. à It is logical table based on one or more tables. à View can be created based on a table is called base table. à DML, DESC, SELECT allowed on views. à To reduce the redundant data (in consistent or duplicate data) to the minimum possible, oracle allows to creation of object called VIEWs. à Advantages View provides high security while sharing between users. View can be used to make simple queries to retrieve the result of complicated queries. à Syntax Create [OR REPLACE] [FORCE] [NOFORCE] VIEW <VIEWNAME> <alias name> as <subquery> [WITH (CHECH OPTION/ READ ONLY) CONSTRAINT <constraint name>]; OR REPLACE : - replace the view if it is already existing. FORCE : - create view even base table does not exist and default. NO FORCE : - create view only if base table exist and default. ALIAS NAME : - specify the...