What is view? Types of views?use of views?how to create view(syntax)?

Showing Answers 1 - 16 of 16 Answers


  • Jan 28th, 2006

1. View is nothing but parsed SQL statement which fetches record at the time of execution.

2.There are mainly two type of views

a) Simple View

b) Complex View

apart from that we can also subdivided views as UpdatableViews and Read only Views.

Lastly there is an another view named as Materialized Views.

3. View is used for the purposes as stated below:

a) Security

b) Faster Response

c) Complex Query solve

4.Syntax is :

Create or replace view([olumn1],[column2]...)


Select column1,column2...

from table_name

[where condition]

[with read only],[with check option]

  Was this answer useful?  Yes

Brajendra Nath Vimal

  • Mar 5th, 2006

View:- View is the vertual or logical or the duplicate copy of the original table with schema parts only.Types Of Views:- i)Readable Viewii) Updatable ViewCreation of view:- Syntax:- Create view As Select A1,A2,.........,An From T1,T2,.............,Tn Where

  Was this answer useful?  Yes

A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that direct represents the view instead a definition of view is stored in data dictionary.
Growth and restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

There are two type of views:

1,simple view

2,complex view

  Was this answer useful?  Yes


  • Nov 29th, 2007

The dynamic result of one or more relational operations operating on base relations to produce new relation.

creating view: create view View_Name as select query.

Basically we use views for 1. to reduce the complexity in writing queries  --> go with view resolution
2. To improve performance --> go with materializing view  (remember if the frequency of executing select query is more than the frequency of updating then only go with this)
Rajavardhan Sarkapally

  Was this answer useful?  Yes

A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables.

Types of Views:
DataBase View
b) Help View
c) Projection View
d) Maintenance View

Use of views
A view provides the mechanism to hide certain data from the view of certain users.

use XXX (your database name)
CREATE VIEW view1(view name)
SELECT -------
-----------------(your query)

  Was this answer useful?  Yes


  • Feb 1st, 2011

A view is a virtual table, which provides access to a subset of columns from one or more tables. It is a query stored as an object in the database, which does not have its own data.

  Was this answer useful?  Yes

raman sharma

  • Mar 2nd, 2012

view is called a temporarily table when we want to create the copy of any table as requirement column then we use the view

create view (view name) as select (* or column name) from (table name);

  Was this answer useful?  Yes


  • May 27th, 2015

Does a view occupy space in the database? In other words, does a view contain any data?

also, When we execute a SELECT statement on a view, where does the data come from?

  Was this answer useful?  Yes


  • Jun 22nd, 2016

What about Dynamic and Materialized views?

  Was this answer useful?  Yes


  • Oct 16th, 2016

VIEW is the virtual table which has ROW and COLUMN on which we can perform JOIN and UPDATE operations



  Was this answer useful?  Yes


  • Apr 22nd, 2017

Create or replace "view Name of View "As "Select Statement"

  Was this answer useful?  Yes


  • May 4th, 2017

View just like table but view does not maintain physical data. Table is maintains physical data.
View is a database object
View contain logical copy of data from table or tables

Types of views:
1. Simple view
2. Composite view or read -only view or join view
3. Force view
4. Materialized view
5. Inline view

  Was this answer useful?  Yes

Wasif Ali

  • Oct 26th, 2017

A view is a virtual table that displays the data from one or more tables.
The basic purpose of using view is to keep data safe and secure from unauthorized and illegal users.

  Was this answer useful?  Yes


  • Nov 13th, 2017

1. Updatable view & Non-updatable view
2. Simple view & complex view
3. Read only view
4. Force view
5. Meterialized view
6. Inline View

  Was this answer useful?  Yes

Lavanish Chaudhary

  • Jul 1st, 2018

A database view is a searchable object in a database that is defined by a query. Types of view in a database management system:
A. Simple view
B. Complex view
C. Readable view
D. Force view
E. Materialized view
F. Inline view

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions