Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53357 Views
- I also Faced
- E-Mail Answers
Answer Posted / ketaki
simple view only contain a single base table, simple view does not contain group by, distinct , pseudocolumn like rownum, simple view does not contain columns defined by expressions , simple view does not contain not null columns from base tables.On such view DML can be performed.
Complex view can be based on more than one table , it can contain group by, distinct , pseudocolumn like rownum, columns defined by expressions can be included in complex views , not null columns that are not selected by simple view can be included in complex view, on such view we can not perform DML operations.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a view and how is it different from a table?
What is a sub query? What are its various types?
Why do you use stored procedures and state some of its disadvantages?
Describe an oracle table?
How to get a list of all background sessions in the database?
Is oracle a language?
What is the recommended interval at which to run statspack snapshots, and why?
How to drop an index?
What are the different types of partitions in oracle?
Can sub procedure/function be called recursively?
Is oracle a programming language?
What is the usage of save points in oracle database?
What is oracle open database communication (odbc)?
What is the data pump export utility?
What is the difference between count (*), count (expression), count (distinct expression)?
