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.
Oracle CREATE VIEW
Let's take an example to create view. In this example, we are creating two tables suppliers and orders first.
Execute the following query to create a view name sup_orders.
Create View Query:Output:
View created. 0.21 seconds
You can now check the Oracle VIEW by this query:Output:
SUPPLIER_ID QUANTITY PRICE 3 35 70 3 26 125 3 18 100 3 rows returned in 0.00 seconds
Oracle Update VIEW
In Oracle, the CREATE OR REPLACE VIEW statement is used to modify the definition of an Oracle VIEW without dropping it.
Execute the following query to update the definition of Oracle VIEW called sup_orders without dropping it.
You can now check the Oracle VIEW by this query:
SUPPLIER_ID QUANTITY PRICE 1 35 70 1 26 125 1 18 100 row(s) 1 - 3 of 3
Oracle DROP VIEW
The DROP VIEW statement is used to remove or delete the VIEW completely.