Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 52827 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 |
What is tns service name?
How to assign a tablespace to a users in oracle?
How many types of synonyms in Oracle?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is an external table?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to experiment a data lock in oracle?
what is kernel?
Oracle General 
