Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53192 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 instant client oracle?
how to clone 9i Database on to 10g Database.
What is the difference between primary key and unique key and foreign key in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is object data modeling?
When system tablespace is created?
What is rowid and rownum in oracle?
What is the fastest query method to fetch data from the table?
How to create tables for odbc connection testing?
What is a trigger oracle?
What the is the diff between local index and global index. give some example.
Difference between the “verify” and “feedback” command?
Oracle
What is difference between cartesian join and cross join?
20. Using a set operator, display the client number of all clients who have never placed an order.
