Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53727 Views
- I also Faced
- E-Mail Answers
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 to pass a cursor variable to a procedure?
How to load a large xml file?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is a sub query? Describe its types?
What is set operator oracle?
How many types of cluster table in Oracle?
How to drop an existing view in oracle?
What are the uses of linked server and explain it in detail?
What privilege is needed for a user to insert rows to tables in another schema?
How to assign query results to variables?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Explain what does a control file contain?
What is the scope of a local variable?
How to rename an existing table?
How to install oracle database 10g xe?
