Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 52939 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramu c
A View is said to be simple view it should have a single
select statement only.Where as a complex view migh contain
select statement with joins, sub queries etc...
| Is This Answer Correct ? | 78 Yes | 13 No |
Answer / niranjan dhungia
sorry for previous ans i had some mistakes....
simple view refers data from only single table but complex
view can refers data from more than one table. In simple
view we can not use group function(eg.avg,sum...) but in
complex view we can use group function.
| Is This Answer Correct ? | 56 Yes | 10 No |
Answer / priya reddy
A View is said to be simple View when it is created
using a single table.
A view is said to be comple view when it is created
on two or more tables
| Is This Answer Correct ? | 51 Yes | 14 No |
A Simple view selects from one table. A Complex view
selects from one or more tables.
A Simple view does not contain functions but Complex views
contain functions.
You can perform DML through Simple views but you cannot
always perform DML through Complex views.
| Is This Answer Correct ? | 38 Yes | 6 No |
Answer / yasi
Simple view derives data from only one table and contains NO functions or groups of data. And can perform DML operation through the view
Complex view derives data from many tables and contains functions or groups of data, It does not always allow DML operations through the view
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / siva kumari
A view which is created by only one table is called simple
view.A view which is created by more than one table (joins
and subquires) is called complex view.
we can not use any group by functions in simple view but we
can use group by function in complex view.
we can perform DML through simple views but we can not
always perform DML through complex view.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / binod
A simple view is the one which is functioned on the single
table.whereas, a complex view is one that's functioned on
multiple table.
Simple view doesn't contains or consists function ,but
complex view contains functions.
In simple view we can't use groups of data but in case of
complex view it allows the group of function
DML operation is perform through simple view ,on the other
hand it is not allowed in case of complex
| Is This Answer Correct ? | 12 Yes | 5 No |
Answer / ali
simple view contains created with only one table whereas
cmplex view is created with more than one table
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
Answer / 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 |
How do I spool in oracle?
What is Partitions in Table ?
Explain how are indexes update?
How can I combine multiple rows into a comma-delimited list in oracle?
Explain an exception?
Explain the use of analyse option in exp command.
what is the bitmap index?
What are the Limitations of a CHECK Constraint ?
What are the different oracle database objects?
What is primefaces used for?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What are the four Oracle system processes that must always be up and running for the database to be useable?
Oracle General 
