Interested to Buy Any Domain ? << Click Here >> for more details...
Can a View based on another View ?
- 3 Answers
- 11755 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 load balancing and what u have used to do this?(sql loader)
How to Remove the 3rd highest salary person record from table?
What is a Schema ?
In Oracle 10g, "g" Stands for what?
What is the maximum limit on the number of columns in a table?
How to write a query with an inner join in oracle?
What is the quickest way to export a table to a flat file?
What are different Oracle database objects?
What is the difference between translate and replace?
What is pragma autonomous transaction in oracle?
What is index-organized table in Oracle?
Why cursor variables are easier to use than cursors?
Oracle General 
