Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53355 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
is there a tool to trace queries, like profiler for sql server?
Which are the five query types available in oracle?
How is it different from a normal table?
How to write a query with a left outer join in oracle?
Give syntax for SQL and ORACLE joins.
What is raw datatype in oracle?
What are the uses of a database trigger?
What do you mean by a tablespace?
What are the different types of partitions in oracle?
What does sharding mean?
What is a user account in oracle?
Whether any commands are used for months calculation? If so, what are they?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How can we delete duplicate rows in a table?
Explain how you would restore a database using RMAN to Point in Time?
