Yes, it is possible. Ex: create or replace view my_view

Can a View based on another View ?

Question Posted / revathi

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

Please Help Members By Posting Answers For Below Questions

How to use attributes of the implicit cursor in oracle?

554

what is Single Byte Overhead...?

2055

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1787

What are the differences between char and varchar2 in oracle?

556

How to execute the package in oracle?

561

What is the difference between online and offline backups?

558

What are the different oracle database objects?

577

Define oracle database

589

How to define an external table with a text file?

576

How to use subqueries with the exists operator in oracle?

604

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1685

How to start your 10g xe server from command line?

539

Explain the difference between sap and oracle?

568

How to rebuild an index in oracle?

543

What are the various constraints used in oracle?

546