what is the difference between simple view and complex view?
- 13 Answers
- 49717 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramu c
A View is said to be simple view it should have a single
select statement only.Where as a complex view migh contain
select statement with joins, sub queries etc...
| Is This Answer Correct ? | 78 Yes | 13 No |
Post New Answer View All Answers
What privilege is needed for a user to create tables in oracle?
What is the fastest query method to fetch data from the table?
Can we write insert statement in function in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What are the differences between lov and list item?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What are transaction isolation levels supported by oracle?
What is a dynamic performance view in oracle?
How to do paging with oracle?
How to retrieve values from data fields in record variables?
How do I call oracle stored procedures that take no parameters?
What is archive log in Oracle?
What is the difference between translate and replace in oracle?
How to call a stored function in oracle?
