Difference between simple view and complex view?

Questions by sharada y

Showing Answers 1 - 7 of 7 Answers

rajakumar_na

  • Nov 17th, 2007
 

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

eswar

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

 

Related Answered Questions

 

Related Open Questions