Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53351 Views
- I also Faced
- E-Mail Answers
Answer Posted / yasi
Simple view derives data from only one table and contains NO functions or groups of data. And can perform DML operation through the view
Complex view derives data from many tables and contains functions or groups of data, It does not always allow DML operations through the view
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
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.
How to pass a cursor variable to a procedure?
What is the max number of columns in an oracle table?
What to do if dba lost the system password?
What are the differences between date and timestamp in oracle?
what are actual and formal parameters?
What do you mean by a tablespace?
How to execute a stored program unit?
How to write a query with an inner join in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to see free space of each tablespace?
Explain about your project and its relation to the current job position you are applying to?
How can windows applications connect to oracle servers?
How to install oracle database 10g xe?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
