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 does Oracle guarantee data integrity of data changes?
How to update a table row with a record?
master table and child table performances and comparisons in Oracle ?
How to drop an index in oracle?
How to invoke the data pump import utility?
Give the various rollback segment states.
What is null value in oracle?
6. Display the client name and order date for all orders using the traditional method.
What are the parameters that we can pass through a stored procedure?
How would you change old and new values in an insert, delete and update triggers?
What is an Oracle index?
How to calculate date and time differences in oracle?
What is archive log in Oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is an oracle database table?