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

What do you mean by a deadlock?

1107

Explain what are clusters?

1153

What is the data pump export utility?

1128

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2172

Why do we need integrity constraints in a database?

1072

What are the different types of trigger and explain its various uses and functions?

1164

What is the string concatenation operator in oracle?

1224

How do I uninstall oracle 11g?

1173

How to get execution path reports on query statements?

1039

How much memory your 10g xe server is using?

1146

How to pass parameters to procedures?

1084

What is truncate oracle?

1010

What is the difference between a user and a schema in oracle?

1075

Write a syntax for update query in oracle?

1071

How to export data to a csv file?

1378