To create a view in Oracle use the Oracle CREATE
VIEW command as seen in this example:
CREATE VIEW view_emp
AS
SELECT empid FROM emp;
This Oracle CREATE VIEW command creates a new
view called VIEW_EMP. Note that this Oracle CREATE VIEW command does not
result in anything being actually stored in the database at all except
for a data dictionary entry that defines this view. This means that
every time you query a view created using Oracle CREATE VIEW, Oracle has
to go out and execute the view and query the database data. We can query
the view like this:
SELECT * FROM view_emp WHERE
empid BETWEEN 500 AND 1000;
And Oracle will transform the query into this:
SELECT * FROM (select empid
from emp) WHERE empid BETWEEN 500 AND 1000;
Related CREATE VIEW Articles:
Oracle Views Tips
Views and Materialized Views
EnterpriseDB: Views
