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
interview questions with answer for cts
What is an oracle?
Explain view?
Can you tell me how to add new column in existing views?how?How is possible?
How to rename an index?
Explain mutating triggers.
What is the max number of columns in an oracle table?
Difference between hot backup vs. Cold backup?
How to insert a record into a table?
What is the data pump export utility?
How can you use check constraints for self referential integrity?
Explain database link?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to define an explicit cursor in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query