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

How to get last row id?

755


Describe the types of sub query?

768


How to export data with a field delimiter?

798


What are the advantages of oracle?

772


What are nested tables?

868


Difference between open_form and call_form in oracle.

889


When do you get a .pll extension in oracle?

918


What is the difference between pre-select and pre-query?

862


Give the various exception types.

753


Give the advantages and disadvantages of clusters.

799


Explain what are the different type of segments?

756


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2145


How to start a specific oracle instance?

828


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2228


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1895