what is the difference between simple view and complex view?
- 13 Answers
- 53980 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 |
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to add another datafile to a tablespace?
What is a read only transaction in oracle?
Please explain drop constraint oracle?
how to find full database size
1 Answers BirlaSoft, Consultancy,
Differentiate between pre-select and pre-query?
how will I find the first 5 highest salaried employees in each dept in oracle.
How does oracle handle read consistency?
What is a Temporary Segment ?
What are the different types of databases?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Oracle General 
