Difference between simple view and complex view?

Questions by sharada y

Showing Answers 1 - 2 of 2 Answers

FeatureSimple ViewsComplex Views
Number of tablesOneOne or more
Contain functionsNoYes
Contain groups of dataNoYes
DML operations through a viewYesNot always

Regards,
Rajakumar.N

  Was this answer useful?  Yes

Bahadar Ayaz

  • Jul 20th, 2011
 

Here are few differences between simple and complex views.
1. A Simple view selects from one table. A Complex view selects from one or more tables.
2. A Simple view does not contain functions but Complex views contain functions.
3. You can perform DML through Simple views but you cannot always perform DML through Complex views.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions