Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53381 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / niranjan dhungia
simple view refer the data from only single table. Complex
view refer data from more than one table. For simple view
we can use group function(avg,sum etc) but in complex view
we can use group function.
| Is This Answer Correct ? | 13 Yes | 43 No |
When do I need to use a semicolon vs a slash in oracle sql?
How will you write a query to get a 5th rank student from a table student_report?
how can we store any pdf file in oracle
Why should I use oracle database?
what's query optimization and without use of IN AND Exist can we get another way data from query
how to delete all duplicate records from a table using subquery?
What is OCI. What are its uses?
How do I limit the number of oracle database connections generated by weblogic server?
what are the advantages of running a database in NO archive log mode?
12. Display the client name in upper case only and in lower case only.
How to omit columns with default values in insert statement in oracle?
How to create a server parameter file?
Oracle General 
