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

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

Answer Question  Select Best Answer