what is the difference between simple view and complex view?
Answer Posted / v v
A Simple view selects from one table. A Complex view
selects from one or more tables.
Both can use group functions..
Simple view can perform DML..
But complex views can't perform DML on parent table: can
perform only in child table
Is This Answer Correct ? | 7 Yes | 8 No |
Post New Answer View All Answers
Does oracle charge for java?
How to write a query with a left outer join in oracle?
How to drop a stored function?
What is proxy method?
What privilege is needed for a user to create indexes in oracle?
How to grant create session privilege to a user in oracle?
What is the purpose of save points in oracle database?
How to assign a tablespace to a users in oracle?
Explain oracle left join with an example?
List out the difference between commit, rollback, and savepoint?
Explain oracle’s server parameter file.
What is an anonymous block?
How to list all user accounts in oracle?
What is PL/SQL ?
Explain alias?