what is the difference between simple view and complex view?
Answer Posted / 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 |
Post New Answer View All Answers
How to define an oracle sub procedure?
When system tablespace is created?
What are the ansi data types supported in oracle?
How to create an initialization parameter file?
How to use "in out" parameter properly?
What is archive log in Oracle?
How to divide query output into groups in oracle?
What are the restrictions on external table columns?
What is Data Dictionary Cache in Oracle?
What is bulk collect in oracle?
How to retrieve the count of updated rows?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What are the various constraints used in oracle?
what is Single Byte Overhead...?
What is the disadvantage of User defind function?