What Is View and Example

SQL – Views – Explanation and Examples. … A view is a virtual table based on the result-set of the Sql query. These are searchable objects in the database. It does not contain its own data but only the data from already existing tables.

Why do we use views in Oracle?

Since a view is based on one common set of SQL, this means that when it is called it’s less likely to require parsing. Security. Views have long been used to hide the tables that actually contain the data you are querying. Also, views can be used to restrict the columns that a given user has access to.

How many types of views are there?

The two main types of views (or “projections”) used in drawings are: pictorial. orthographic.