Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53360 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagababu
1. A Simple view selects from one table. A Complex view selects from one or more tables.
2. A Simple view does not contain functions but Complex views contain functions.
3. You can perform DML through Simple views but you cannot always perform DML through Complex views.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to list all user accounts in oracle?
How to rename a tablespace in oracle?
What are the different types of database objects?
Explain what are the type of synonyms?
What is a subquery in oracle?
What are the oracle built-in data types?
What is the usage of control file in oracle?
What is connection pooling in oracle?
What is set verify off in oracle?
Calculate difference between 2 date / times in oracle sql?
What is rowid and rownum in oracle?
What is meant by an index?
Explain the use of indexes option in exp command.
What is the use of aggregate functions in oracle?
