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 check database size in Oracle?

1113

Explain cascading triggers.

1011

What is the usage of save points in oracle database?

904

How to define a sub function?

1080

what is a Nested Loop join?

2038

What is a sub query? Describe its types?

962

In what script is snap$ created? In what script is the scott/tiger schema created?

2653

query optmization techniques and quwry analyser+projects+ppts

2369

What is the difference between substr and instr?

974

How to create a new table in oracle?

1064

What are the various types of snapshots ?

970

What is meant by raw datatype?

1000

Can you create a synonym without having a table?

976

What is dynamic proxy?

958

Briefly explain what is literal? Give an example where it can be used?

969