what is the difference between simple view and complex view?
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 to rename a tablespace in oracle?
what is meant by magic query
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
Explain oracle instance.
how to make an oracle object
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Explain the different normalization forms?
From the database level, how can you tell under which time zone a database is operating?
What is catalog in Oracle?
What is a snapshot in oracle database?
Why we choose emp number as primarykey?
Can Multiple instances be run on Single Machine???