Difference between simple view and complex view?

Questions by sharada y

Showing Answers 1 - 3 of 3 Answers

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


  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


  • Dec 28th, 2016

Basically a simple and complex views can be differentiated based on the relations, functions and groups of data not by number of tables in the views.

Ex: We can not apply Insert, Delete and Update on a complex view directly, Let us say we have column returning the count in a view.
The same can be possible on a simple view.

  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