Can a View based on another View ?

Question Posted / guest

Answers were Sorted based on User's Feedback

Can a View based on another View ?..

Answer / guest

Yes a view can be created based on another view. Like this
views can be created upto 32 levels.

Is This Answer Correct ?

11 Yes

0 No

Can a View based on another View ?..

Answer / 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

Can a View based on another View ?..

Answer / nishi

Yes

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

Explain how you would restore a database using RMAN to Point in Time?

what is RAID technology?which is better RAID 0+1 OR RAID 5?

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

What is the difference between sharding and partitioning?

how to unbreak sequence numbers during intereptions

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

What is the disadvantage of User defind function?

What is meant by a deadlock situation?

How do you bind variables in oracle?

how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

How to delete all rows a table in oracle?

For more Oracle General Interview Questions Click Here