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:

Oracle VIEWS

Related Code Snippets:

Create View - Basic syntax for creating a view.
INSERT: Single Column Table Or View - Simple single table/column SELECT examples.
INSERT: Multiple Column Table Or View (All Columns) - Simple insert examples (multiple column ins...
INSERT: Multiple Column Table Or View (Not all columns) - INSERT example with multiple columns, t...
VIEW - A view is a SQL statement stored in the database in the system tablespace. Data for a view ...
Materialized View - A materialized view is a database object that contains the results of a query....
USERS: view all active users - View all actively connected users in the system.
USERS: view currently connected users - View all of the currently connected users on the system. H...
USERS: view specific user info - View information on a specific Oracle user.
INDEXES: View table indexes - Examples of viewing the indexes on an Oracle table. Replace the exam...
LOCKS: View Locked Objects - List out all currently locked objects in the database.

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us

PSOUG LOGIN
Username:
Password: