Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53721 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 are the limitations oracle database 10g xe?
Can we use bind variables in oracle stored procedure?
How to build data dictionary view an new database?
Explain the function of optimizer in oracle?
Which is better Oracle or MS SQL? Why?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to get last row id?
What is an anonymous block?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to get a list of all user accounts in the database?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is define in oracle?
What are the common oracle dba tasks?
Can we write dml statement in function in oracle?
What is pragma autonomous transaction in oracle?
