Views are acceptable when you want to restrict users to a particular subset of data. For instance, if you do not delete records but only mark the current one as active and the older versions as inactive, you want a view to use to select only the active records.

What is a view used for?

Views are used for security purposes because they provide encapsulation of the name of the table. Data is in the virtual table, not stored permanently. Views display only selected data. We can also use Sql Join s in the Select statement in deriving the data for the view.

What is a view and what are the types of views?

Types of Views Complex View: A view based on multiple tables, which contain GROUP BY clause and functions. Inline View: A view based on a subquery in FROM Clause, that subquery creates a temporary table and simplifies the complex query. Materialized View: A view that stores the definition as well as data.