Quick Search:
 
 The Oracle VIEW      [Return To Index] Jump to:  
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")

Term: VIEW

Definition:
A view is a representation of a SQL statement that is stored in memory so that it can be re-used. A view is a logical entity or logical table that is essentially a SQL statement stored in the database in the system tablespace. Data for a view is built in a table created by the database engine in the TEMP tablespace. You may also want to visit the Oracle CREATE_VIEW Statement page for additional syntax and examples on views.

Example Syntax:

CREATE OR REPLACE VIEW <view_name> AS

  SELECT <column_name>

  FROM <table_name>

WHERE <predicates>;


Example Usage:

CREATE VIEW sales_map

AS

SELECT sales FROM sales_areas;


This command creates a new view called "sales_map". Creating a view doesn't result in anything being stored in the database except for a data dictionary definition that contains the view parameters.

Views are frequently used to hide the tables that contain the actual data that is queried. As a low-level form of security, views can be used to restrict the columns that a particular user has access to.

You may want to visit the Oracle CREATE_VIEW Statement page for additional syntax and examples on views.

Related Links:
Related Code Snippets:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2025 psoug.org