what is the difference between simple view and complex view?
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
How to rename an index?
How to write a query with a right outer join in oracle?
What is the usage of merge statement?
What are the system predefined user roles?
What is the difference between a primary key & a unique key?
What is key preserved table?
How to start your 10g xe server?
How to experiment a data lock in oracle?
What are oracle functions?
Explain the use of inctype option in exp command.
What are the differences between char and nchar in oracle?
How to pass parameters to procedures in oracle?
Explain rename?
What is a snapshot in oracle database?
How to recover a dropped table in oracle?