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
How many data types are supported?
How can I combine multiple rows into a comma-delimited list in oracle?
How to get last row id?
how do u setup a replication site?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to assign query results to variables?
How to convert character types to numeric types?
How to export several tables together?
How to rename a column in an existing table?
Explain the use of owner option in exp command.
How do I recompile a procedure in oracle?
How can I get column names from a table in oracle?
What is a select query statement in oracle?
Is java required for oracle client?
What is clustered table in Oracle?