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>;

CREATE VIEW sales_map

AS

SELECT sales FROM sales_areas;

• Oracle VIEWS

• 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.