what is the difference between simple view and complex view?
Answers were Sorted based on User's Feedback
Answer / paul james
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 ? | 0 Yes | 0 No |
Answer / v v
A Simple view selects from one table. A Complex view
selects from one or more tables.
Both can use group functions..
Simple view can perform DML..
But complex views can't perform DML on parent table: can
perform only in child table
Is This Answer Correct ? | 7 Yes | 8 No |
Answer / niranjan dhungia
simple view refer the data from only single table. Complex
view refer data from more than one table. For simple view
we can use group function(avg,sum etc) but in complex view
we can use group function.
Is This Answer Correct ? | 13 Yes | 43 No |
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
How to create a temporary table in oracle?
What is the usage of analyze command in oracle?
What are the differences between interval year to month and interval day to second?
Explain the use of record option in exp command.
What do you mean by a deadlock?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
How to use subqueries in the from clause in oracle?
can you explain performance tunning in oracle(sql,PL/SQL)
How to call a stored procedure inside a trigger? Give an example.
Explain the difference between sql and oracle?
What is the minimum client footprint required to connect c# to an oracle database?