| A | B |
|---|
| ROWNUM | a pseudocolumn which assigns a sequential value starting with 1 to each of the rows returned from the subquery. |
| CREATE OR REPLACE VIEW | recreates or creates a view. |
| FORCE | creates a view regardless of whether or not the base tables exist. |
| INLINE VIEW | subqueries with an alias that can be used within a SQL statement |
| WITH CHECK OPTION | specifies that INSERTS and UPDATES performed through the view can't create rows which the view cannot select. |
| DROP VIEW | removes a view |
| View | a table of logical subsets or combinations of data based on a table or another view. |
| Simple View | derives data from a table, no functions or groups, performs DML operations through the view. |
| 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. |
| TOP-N Analysis | asks for the N largest or smallest values in a column. |
| CREATE VIEW | creates a view by embedding a subquery within it. |
