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
Can we store images in oracle database?
What happens to the current transaction if the session is ended?
Difference between varchar and varchar2 data types?
How to count groups returned with the group by clause in oracle?
How to create a new table in your schema?
What is oracle instant client?
Explain the use of inctype option in exp command.
How to initialize variables with default values?
How to get the Installed Oracle Version Information ?
What is oracle in java?
Explain the use of full option in exp command.
How to define an anonymous procedure with variables?
what is dynamic SGA and static SGA
How to lock and unlock a user account in oracle?
What are the different types of record groups in oracle? Explain each of them