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
How to change user password in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What are the differences between char and varchar2 in oracle?
Can we write insert statement in function in oracle?
What is the data pump export utility?
Where do we use decode and case statements?
What is ASM (Automatic Storage Management) in Oracle?
What is literal?
Differentiate between translate and replace?
How to create a server parameter file?
What is truncate oracle?
How to do a full database export?
Why does for update in oracle 8 cause an ora-01002 error?
 What are the oracle DML commands possible through an update strategy?
Explain the use of Merge statement in oracle 11g