Diksha IT Training Centre

                               Views and Types of View in Oracle.   Hello Everyone, In this blog I will discuss about Views and types of Views in Oracle Database .Views plays very important role in database as   Views are Virtual table that can be created from existing or base table. A view can be known as a ‘Stored Query’ or a “Virtual Table”. Views mainly used for security purpose and view used in most places where a table can be used. The table from which view is created are called based table. We can query view just like a table , but views doesn’t required disk space. A view representing a subset of the data present in a table, and performing functions such as joining and simplification of multiple tables into a single table, data aggregation, handling data complexity, providing security etc. A view can be created by SQL DDL create command i.e Create view statement View can be created from single base table or can be created from multiple tables by using joins, aggregate