what is the difference between simple view and complex view?
Answer Posted / binod
A simple view is the one which is functioned on the single
table.whereas, a complex view is one that's functioned on
multiple table.
Simple view doesn't contains or consists function ,but
complex view contains functions.
In simple view we can't use groups of data but in case of
complex view it allows the group of function
DML operation is perform through simple view ,on the other
hand it is not allowed in case of complex
Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
How to run create database statement again?
Is postgres faster than oracle?
How to convert character types to numeric types?
What is Library Cache in Oracle?
What is max rowid in oracle?
How to see the table columns used in an index?
Briefly explain what is literal? Give an example where it can be used?
Explain the blob datatype?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
IS it possible to built the oracle database without setting the kernal parameters?
what is insert all statement in sql
How to define default values for formal parameters?
Explain what are the characteristics of data files?
Differentiate between function and procedure in oracle.
what are bitmap indexes? How does they work?