Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 52816 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 are the components of logical database structure in oracle database?
Can we create database in oracle using command line ?
How do I connect to oracle?
how to make an oracle object
What are the ways tablespaces can be managed and how do they differ?
Explain the difference between sap and oracle?
What happens if you lost a data file?
What is an oracle wallet?
What is oracle rownum?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What happens to the data files if a tablespace is dropped?
Explain about your project and its relation to the current job position you are applying to?
How can I see all tables in oracle?
What are the attributes of the cursor?
how the indexes are stored in the Oracle Database?
