Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53380 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 insert multiple rows with one insert statement in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
Can we connect to ORACLE db using Windows Authentication?
what are steps for interface? where is exchange rate defined in which table?
What is sharded cluster?
Difference between varchar and varchar2 data types?
What are the different oracle database objects?
Can we write insert statement in function in oracle?
How to do a full database export?
what is port in oracle? how is it related to database application.
How to load data from external tables to regular tables?
How to create a table index in oracle?
What's dateware house and what's clustor with practicle example
What is the dynamic sql in oracle?
How to connect to oracle using service name instead of sid?
