Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53382 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 |
What is transport network substrate (tns) in oracle?
Give the constructs of a package, function or a procedure.
How to end the current transaction in oracle?
What is ADDM Advisor in Oracle?
what is difference between where clause and having clause?
Does rowid change in oracle?
how to insert the image in table
Why does Oracle not permit the use of PCTUSED with indexes?
How to create a new table in your schema?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
What is a Data File ?
How to get the Installed Oracle Version Information ?
Oracle General 
