Interested to Buy Any Domain ? << Click Here >> for more details...
Can a View based on another View ?
- 3 Answers
- 11819 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 Data Block ?
What is difference between SQL and SQL*PLUS?
What is a static data dictionary in oracle?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
What is oracle rownum?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is the scenario where you take the database to NoArchivelog mode?
how to find find & delete duplicate rows from two different tables?
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
Why is oracle so popular?
What is columnar storage what is the advantage?
Oracle General 
