SQL - What is Complex View?Where we can use?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 99 of 169

What is Complex View?
Where we can use?

Total Answers and Comments: 3

Last Update: February 18, 2007 Asked by: vasudeva123

Sponsored Links

Best Rated Answer

—

Submitted by: ddkdhar

we go for complex views when we want to display from two or more tables, using group cluase, or grouping, aggregate functions

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

September 13, 2006 08:10:32

Pankaj Gauba

RE: What is Complex View?Where we can use?

View developed by join of two or more table is called Complex view

Is this answer useful? Yes | No

September 14, 2006 08:33:01

Venkata Ramana

RE: What is Complex View?Where we can use?

Views containing any group functions or joining tables are known as complex views.

Is this answer useful? Yes | No

February 18, 2007 09:55:19

ddkdhar

Member Since: June 2006 Contribution: 48

RE: What is Complex View?Where we can use?

we go for complex views when we want to display from two or more tables, using group cluase, or grouping, aggregate functions

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top