Interested to Buy Any Domain ? << Click Here >> for more details...
Can a View based on another View ?
- 3 Answers
- 11692 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Yes a view can be created based on another view. Like this
views can be created upto 32 levels.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / revathi
Yes, it is possible.
Ex:
create or replace view my_view_3 as
select mv1.id, mv1.name, mv1.address
from my_view_1 mv1.
mv1 IS A ANOTHER VIEW
| Is This Answer Correct ? | 3 Yes | 0 No |
How to resolve the ORA-39133 error in Oracle?
Where do you use decode and case statements?
can you write commit in triggers?
Explain an extent?
find the second highest salary of the emp table
What do you understand by a database object?
Describe an oracle table?
Are truncate and delete commands same? If so why?
What is recovery manager(rman) backup in Oracle?
How to find the date and time of last updated table?
What do database buffers contain?
What is an Index ?
Oracle General 
