what is the difference between simple view and complex view?
- 13 Answers
- 53979 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
How to select all columns of all rows from a table in oracle?
How to write a left outer join with the where clause in oracle?
How to use values from other tables in update statements using oracle?
How to start an oracle instance?
How to put more than 1000 values into an oracle in clause?
Design database draw er diagram for a certain scenario ?
What is oracle latest version?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
