what is the difference between simple view and complex view?
Answer Posted / subbu
A Simple view selects from one table. A Complex view
selects from one or more tables.
A Simple view does not contain functions but Complex views
contain functions.
You can perform DML through Simple views but you cannot
always perform DML through Complex views.
Is This Answer Correct ? | 38 Yes | 6 No |
Post New Answer View All Answers
What are the oracle differences between nvl and coalesce
How do I uninstall oracle client from windows?
What is not equal to in oracle?
What is transport network substrate (tns) in oracle?
How to define a data field as not null?
How to define a sub function?
Explain the different normalization forms?
How to get a list of all user accounts in the database?
How to enter a new row into a table interactively?
How can I get column names from a table in oracle?
What to do if the binary spfile is wrong for the default instance?
What is the difference between primary key and unique key and foreign key in oracle?
How do we represent comments in oracle?
What is meant by joins? List out the types of joins.
What is oracle rownum?