Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53191 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is Java Pool in Oracle?
How to count duplicated values in a column in oracle?
How to empty your oracle recycle bin?
Explain the dml?
Explain rename?
Is oracle the best database?
Give the constructs of a package, function or a procedure.
What are a cluster and non-cluster index?
Briefly explain what is literal? Give an example where it can be used?
How to use "out" parameter properly?
is there a tool to trace queries, like profiler for sql server?
What are the various constraints used in oracle?
State some uses of redo log files?
What are transaction isolation levels supported by oracle?
How many categories of data types in oracle?
