what is the difference between simple view and complex view?
Answer Posted / niranjan dhungia
sorry for previous ans i had some mistakes....
simple view refers data from only single table but complex
view can refers data from more than one table. In simple
view we can not use group function(eg.avg,sum...) but in
complex view we can use group function.
| Is This Answer Correct ? | 56 Yes | 10 No |
Post New Answer View All Answers
How to create a table index?
What is blob datatype?
What are the different oracle database objects?
What is a initialization parameter file in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Explain the blob datatype?
What are the differences between char and nchar in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
defination of bitmap index
How to create a single index for multiple columns?
How to use "startup" command to start default instance?
What is a relational database management system?
How to login to the server without an instance?
What is the difference between Delete, Truncate and Drop in Oracle?
How to set a transaction to be read only in oracle?