what is the difference between simple view and complex view?
Answer Posted / niranjan dhungia
sorry for previous ans i had some mistakes....
simple view refers data from only single table but complex
view can refers data from more than one table. In simple
view we can not use group function(eg.avg,sum...) but in
complex view we can use group function.
| Is This Answer Correct ? | 56 Yes | 10 No |
Post New Answer View All Answers
What is the string concatenation operator in oracle?
How to name query output columns in oracle?
Is truncate autocommit in oracle?
How many types of auditing in Oracle?
How would you change old and new values in an insert, delete and update triggers?
What are the differences between lov and list item?
How would you begin to troubleshoot an ORA-3113 error?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to assign a tablespace to a users in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
What is literal?
Explain a data segment?
What are the ansi data types supported in oracle?
State the difference between a primary key and foreign key?
How to convert characters to times in oracle?