Question

ORACLE:

What is a VIEW and how it is used ?

Answer 1

In Oracle, view is a virtual table that does not physically exist. It is stored in Oracle data dictionary and do not store any data. It can be executed when called.

A view is created by a query joining one or more tables.

CREATE VIEW :-

CREATE VIEW view_name AS  

SELECT columns  

FROM tables  

WHERE conditions;  

USE:- use view as a table name example

SELECT * FROM view_name;