Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53399 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 |
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to turn on or off recycle bin for the instance?
how to produce numbers from 1 to 10 using dual table
How does Oracle guarantee data integrity of data changes?
In Oracle 9i what does "i" Stands for?
How to speed up webrick?
What are the different types of modules in oracle forms?
Display the records between two range?
What is the difference between sharding and partitioning?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
Oracle General 
