Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53719 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / paul james
A Simple view selects from one table. A Complex view selects from one or more tables.A Simple view does not contain functions but Complex views contain functions.You can perform DML through Simple views but you cannot always perform DML through Complex views.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / v v
A Simple view selects from one table. A Complex view
selects from one or more tables.
Both can use group functions..
Simple view can perform DML..
But complex views can't perform DML on parent table: can
perform only in child table
| Is This Answer Correct ? | 7 Yes | 8 No |
Answer / niranjan dhungia
simple view refer the data from only single table. Complex
view refer data from more than one table. For simple view
we can use group function(avg,sum etc) but in complex view
we can use group function.
| Is This Answer Correct ? | 13 Yes | 43 No |
What are ACID properties in databases?
What is translate in oracle?
What are nested tables?
Where are the settings stored for each instance in oracle?
What is rowid and rownum in oracle?
How many types of cluster table in Oracle?
How to retrieve data from an explicit cursor?
How to connect asp pages to oracle servers?
what is the difference between substr and instr function in oracle?
1.display list of all users from ur data base.what is the query?
What is bulk copy or bcp in oracle?
Explain how you would restore a database using RMAN to Point in Time?
Oracle General 
