SQL - What is a view ?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 5 of 171

What is a view ?

A view is stored procedure based on one or more tables, it’s a virtual table.

Total Answers and Comments: 13

Last Update: September 16, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: Paramjeet singh

view is a window to see data from one or more tables.

Above answer was rated as good by the following members:
satyam_Ora

Sorting Options

Page 1 of 2

« First

Last »

March 29, 2005 13:02:50

G.Sreenivasulu

RE: What is a view ?

A view may also be defined as custom-tailored (data presented to meet requirement) presentation of data from more than one table
A view is stored inside the database as a select query.
It does not have any data of its own but it only fetches data from base tables by executing the query written at the time of its creation

Is this answer useful? Yes | No

September 15, 2005 03:10:54

Paramjeet singh

RE: What is a view ?

view is a window to see data from one or more tables.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 06, 2005 02:21:00

Raja Sekhar

RE: What is a view ?

View Is a Customized data representation Of Based on One or more tables .

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 10, 2005 04:55:14

Ramesh. S

RE: What is a view ?

View is not a stored procedure.it is also a table it will contains the organised fields of one or more than one tables.

Is this answer useful? Yes | No

December 12, 2005 13:23:37

manju thanikonda

RE: What is a view ?

view: Logically represents subset of data from one or more tables

Is this answer useful? Yes | No

1 0

Overall Rating: +1

April 20, 2006 01:55:46

Kanchan

RE: What is a view ?

Logical representation of data which is created by group of table also called as base tables

Is this answer useful? Yes | No

1 0

Overall Rating: +1

April 26, 2007 10:36:52

Jyothsna

What is a view ?

A view takes the output of a query and treats it as a table.
So view is a "stored query " and " virtual table"

Is this answer useful? Yes | No

August 08, 2007 11:33:54

Sujatars

Member Since: December 2006 Contribution: 217

RE: What is a view ?

View is a virtual table based on the result set of a SELECT statement. The fields in the view are fields from one or more real table.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

August 08, 2007 22:38:30

bambino chakma

RE: What is a view ?

View is a vartual table of logically represented data from one or more no. of table

Is this answer useful? Yes | No

August 08, 2007 22:46:39

#10

bambino_chakma

Member Since: July 2007 Contribution: 7

RE: What is a view ?

View is a virtual table of logically represented data from one or more no. of table.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank