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
Explain oracle insert into command?
Which is better Oracle or MS SQL? Why?
interview questions with answer for cts
Differentiate between translate and replace?
How to call a stored function in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
When system tablespace is created?
How to synchronize 2 schema's objects?
What is data block in Oracle?
Give the various rollback segment states.
Point out the difference between user tables and data dictionary?
How to resolve name conflicts between variables and columns?
What is the difference between translate and replace?
What does sharding mean?
What is a trigger and what are its types in oracle?