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
State the difference between a primary key and foreign key?
Explain the features of oracle?
What language does oracle use?
What are a cluster and non-cluster index?
Why does for update in oracle 8 cause an ora-01002 error?
What is an oracle database table?
How to enter a new row into a table interactively?
Please explain drop constraint oracle?
What is blob data type in oracle?
Explain table?
What are the arithmetic operations?
What is a database table in oracle?
How to check database size in Oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain parameter file in oracle.