Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53193 Views
- I also Faced
- E-Mail Answers
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
What is query image?
Explain oracle’s system global area (sga).
Explain the use of full option in exp command.
what is IDE,DMV in sql server?
How to drop a tablespace?
Why do we use coalesce function in oracle?
What are oracle functions?
How to add another datafile to a tablespace?
What is the best way to do multi-row insert in oracle?
Name the three major set of files on disk that compose a database in Oracle?
Explain integrity constraints?
How would you change old and new values in an insert, delete and update triggers?
How to start instance with a minimal initialization parameter file?
How to rename a column in an existing table?
How to calculate date and time differences in oracle?
