Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle VIEW      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 101 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?