VIEW in SQL
VIEW is a virtual table, through which a selective portion of the data from one or more tables.
It is used to make the complex query in easy format. You make the view for complex query fetching data for reports function in Oracle.
CREATE VIEW view_name
SELECT column_list FROM table_name [WHERE condition];
CREATE VIEW view_product
AS SELECT product_id, product_name FROM product;