what is the difference between simple view and complex view?
Answer Posted / nagababu
1. A Simple view selects from one table. A Complex view selects from one or more tables.
2. A Simple view does not contain functions but Complex views contain functions.
3. You can perform DML through Simple views but you cannot always perform DML through Complex views.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain user account with reference to oracle.
How can you use check constraints for self referential integrity?
What is a sub query? Describe its types?
Can we write insert statement in function in oracle?
How to define a procedure inside another procedure?
How translate command is different from replace?
What is oracle instant client?
What is archive log in Oracle?
What are the attributes that are found in a cursor?
What is transaction control statement and how many types of transaction control statement in Oracle?
What are group functions in oracle?
How to list all user accounts in oracle?
How to create a new tablespace in oracle?
How would you change old and new values in an insert, delete and update triggers?
What do you know about normalization? Explain in detail?