what is the difference between simple view and complex view?
Answer Posted / 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 |
Post New Answer View All Answers
How to delete all rows a table in oracle?
What is an oracle cursor variable?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How do I know if oracle client is installed on windows?
How to apply filtering criteria at group level in oracle?
How to create a testing table in oracle?
 How to use an oracle sequence generator in a mapping?
Can you tell me how to add new column in existing views?how?How is possible?
Difference between open_form and call_form in oracle.
How to use subqueries with the in operator using oracle?
Write a trigger example in oracle?
Explain the use of parfile option in exp command.
Explain what are synonyms used for?
What exactly do quotation marks around the table name do?
What is different types of joins?