DIPTENDU HUI

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

as

Select column1,column2...

from table_name

[where condition]

[with read only],[with check option]

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

sreyaskvmce&it

 Profile Answers by sreyaskvmce&it 

• Mar 18th, 2006

 

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

sari_pot

 Profile Answers by sari_pot Questions by sari_pot

• Oct 18th, 2007

 

A view is a virtual table whose contents are defined by a query.As per sql server 2005 we can create standard,indexed and partitioned views.

srvardhan

 Profile Answers by srvardhan 

• 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

nithui

 Profile Answers by nithui Questions by nithui

• Mar 12th, 2009

 

View:
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:
a)
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.

Syntax:
use XXX (your database name)
GO
CREATE VIEW view1(view name)
AS
SELECT -------
-----------------(your query)
-----------------

sachinbbau

 Profile Answers by sachinbbau 

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

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

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

AJGrooms

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

sneha

• Jun 22nd, 2016

 

What about Dynamic and Materialized views?

JAY

• Oct 16th, 2016

 

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

SYNTAX

CRETE VIEW [PRODUCT_LIST] AS
SELECT * FROM PRODUCT
WHERE DISCOUNT=0

Ahmad

• Apr 22nd, 2017

 

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

siva

• 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

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.

Nagaraj

• 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

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