Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 52818 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 the use of oracle?
How to list all user accounts in oracle?
What is the difference between $oracle_base and $oracle_home?
What's dateware house and what's clustor with practicle example
What is sharded cluster?
What is tns service name?
How to manage transaction isolation level?
What are the different oracle database objects?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Explain the use of consistent option in exp command.
Query to retrieve record for a many to many relationship ?
What is a initialization parameter file in oracle?
How to use values from other tables in update statements using oracle?
What types of joins are used in writing subqueries?
How does the on-delete-cascade statement work?
