what is the difference between simple view and complex view?
Answer Posted / 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 |
Post New Answer View All Answers
Please explain oracle left join with an example?
How to test null values?
What is bulk collect in oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Explain the use of full option in exp command.
Explain what are the type of synonyms?
What is oracle rownum?
What is the difference between translate and replace?
Explain the difference between replace() and translate() functions in oracle?
What is the difference between hot backup and cold backup in oracle?
What is integrity and what is constraint??Explain with example
Can multiple cursors being opened at the same time?
What is a nvl function? How can it be used?
How to create a new user account in oracle?
How to drop an index?