Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 52803 Views
- I also Faced
- E-Mail Answers
Answer Posted / siva kumari
A view which is created by only one table is called simple
view.A view which is created by more than one table (joins
and subquires) is called complex view.
we can not use any group by functions in simple view but we
can use group by function in complex view.
we can perform DML through simple views but we can not
always perform DML through complex view.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Explain the use of show option in imp command.
Explain integrity constraint?
Can I create users through internet explorer in oracle 10g?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Where are the settings stored for each instance in oracle?
What is enter substitution variable in oracle?
How to create a single index for multiple columns?
What are the various constraints used in oracle?
What operating systems are supported by oracle database 10g xe?
What is oracle used for?
What is Segment Advisor in Oracle?
How to rename an existing table?
How to retrieve values from data fields in record variables?
What are the different oracle database objects?
How to convert a date to char in oracle? Give one example.
