Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53725 Views
- I also Faced
- E-Mail Answers
Answer Posted / niranjan dhungia
simple view refer the data from only single table. Complex
view refer data from more than one table. For simple view
we can use group function(avg,sum etc) but in complex view
we can use group function.
| Is This Answer Correct ? | 13 Yes | 43 No |
Post New Answer View All Answers
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How will you write a query to get a 5th rank student from a table student_report?
How to rebuild an index in oracle?
How can we find out the current date and time in oracle?
What is a oracle database?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is rich query?
What is the order of defining local variables and sub procedures/functions?
Can a formula column be obtained through a select statement ?
What do you understand by a database object?
Can a parameter be passed to a cursor?
What is blob data type in oracle?
What is the data pump import utility?
Explain self joins in oracle?
How many categories of data types?
