Can a View based on another View ?
- 3 Answers
- 11215 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
what is the syntax of INSERT command?
How do you store pictures in a database?
How to assign values to data fields in record variables?
What is the oracle implicit cursor?
What is primefaces used for?
How to convert csv to table in oracle?
How to write a left outer join with the where clause in oracle?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
How do you handle duplicate records in a database?
What is the difference between SQL and SQL Server?
What is an oracle cursor variable?
What are Clusters ?
Oracle General 
