Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53210 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 should be the return type for a cursor variable.Can we use a scalar data type as return type?
How to generate query output in html format?
How to add a new column to an existing table with a default value?
Explain index?
What privilege is needed for a user to create views in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Explain the use of file option in exp command.
How to return top 5 rows in oracle?
What is the difference between sharding and replication?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
What are the basic element of Base configuration of an oracle Database ?
What is the usage of control file in oracle?
Oracle General 
