Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53359 Views
- I also Faced
- E-Mail Answers
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
What are the differences between char and nchar in oracle?
what is the difference between functional dependecy and multilevel dependency?
What is tns entry?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to create a new tablespace in oracle?
What are the different windows events activated at runtime ?
What are the limitations of check constraint?
What are the differences between blob and clob in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What are the predefined tablespaces in a database?
What is recovery manager(rman) backup in Oracle?
What do you mean by merge in oracle and how can we merge two tables?
How to define a variable to match a table column data type?
What is the difference between sharding and partitioning?
How to define an external table with a text file?
