Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 52828 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 happens if the update subquery returns multiple rows?
Write a trigger example in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
How to execute a stored procedure in oracle?
What is oracle update statement with inner join ?
What is an oracle database?
How to use values from other tables in update statements using oracle?
How to convert characters to times in oracle?
What are the set operators union, union all, minus & intersect meant to do?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What are the different types of modules in oracle forms?
What do you mean by group by clause?
What is a server parameter file in oracle?
What is system tablespace?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
