Can a View based on another View ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain oracle insert into command?

872


Which is better Oracle or MS SQL? Why?

4483


interview questions with answer for cts

2362


Differentiate between translate and replace?

843


How to call a stored function in oracle?

780


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1904


When system tablespace is created?

811


How to synchronize 2 schema's objects?

1940


What is data block in Oracle?

881


Give the various rollback segment states.

837


Point out the difference between user tables and data dictionary?

786


How to resolve name conflicts between variables and columns?

820


What is the difference between translate and replace?

843


What does sharding mean?

796


What is a trigger and what are its types in oracle?

785