| A | B |
|---|
| View | A table of logical subsets or combinations of data based on a table or another view |
| VIEW_NAME | Name of view |
| FORCE | Creates a view regardless of whether or not the base tables exist |
| Simple view | Derives data from a table, no functions or groups, performs DML operations through the view |
| NOFORCE | Creates the view only if the base table exists |
| CREATE VIEW | Creates a view by embedding a subquery within it |
| Alias | Specifies a name for each expression selected by the view’s query |
| Subquery | A complete SELECT statement |
| Complex view | Derives data from more than one table, contains functions or groups of data, and does not always allow DML operations through the view |
| REPLACE | Re-creates the view if it already exists |
| Simple View | The subquery derives data from only one table and it does not contain a join function or any group functions |
| ROWNUM | A pseudo-column which assigns a sequential value starting with 1 to each of the rows returned from the subquery |
| WITH CHECK OPTION | Specifies that INSERTS and UPDATES performedthrough the view can’t create rows which the view cannot select |
| WITH READ ONLY | Ensures that no DML operations can be performed on this view |
| TOP- N-ANALYSIS | Asks for the N largest or smallest values in a column |
| DROP VIEW | Removes a view |
| INLINE VIEW | Subqueries with an alias that can be used within a SQL statement |
