what is the difference between simple view and complex view?
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
What is clustered table in Oracle?
What is a package ? What are the advantages of package ?
what is the dual table in oracle?
How to empty your oracle recycle bin?
What is the difference between translate and replace in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is oracle rowcount?
Does facebook use oracle?
How to rename a column in an existing table?
Explain the use of grant option in imp command.
How to start instance with a minimal initialization parameter file?
What is the difference between primary key and unique key and foreign key in oracle?
Give the constructs of a package, function or a procedure.
What is the difference between a hot backup and a cold backup in oracle?
What is a select query statement in oracle?