Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53195 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagababu
1. A Simple view selects from one table. A Complex view selects from one or more tables.
2. A Simple view does not contain functions but Complex views contain functions.
3. You can perform DML through Simple views but you cannot always perform DML through Complex views.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What happens in oracle commit?
How to create a table interactively?
Explain a data segment?
How to write a query with a right outer join in oracle?
What is an index associated with a constraint?
What is a data dictionary and how can it be created?
Is a rollback possible to any savepoint?
What are the different types of partitions in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Give the various exception types.
What is a cursor and what are the steps need to be taken?
What are the different types of record groups in oracle? Explain each of them
Can we protect our pl/sql source code?
Who developed oracle & when?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
