Pankaj Gauba

• Sep 13th, 2006

 

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

Venkata Ramana

• Sep 14th, 2006

 

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

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 18th, 2007

 

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

prasadraja07

 Profile Answers by prasadraja07 

• Aug 4th, 2010

 

1) View is virtual table and imaginery table
2) We can join two are more tables.
3) It will accept DML Statement...

subhransu mohapatra

• Nov 2nd, 2011

 

It will not accept DML statement..because complex view contain multiple table...therefore oracle can't understand which data will insert or update in which table...

kranthi swaroop

• Dec 3rd, 2011

 

In simple way

View is a mirror to a master table..

View are two types

1) SIMPLE View
2) COMPLEX View

We will not Define anywhere SIMPLE or COMPLEX while creating a view.

Depending Upon the query we can tell SIMPLE or COMPLEX view will be created..

For Example

IN SIMPLE VIEW, there will no
JOIN clause,
Group By Clause,
Order by Clause

Example for SIMPLE View

create view simplview as
Select Ename from emp where deptno ='20';

Example For COMPLEX View

Query with join contd , group by clause


Hope now u got it...