Interested to Buy Any Domain ? << Click Here >> for more details...
Can a View based on another View ?
- 3 Answers
- 11664 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 |
Give the advantages and disadvantages of clusters.
What is oracle datasource?
How to generate query output in html format?
where we have to use ON clause and where we have to use USING clause in JOINS
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is trigger associated with the timer ?
Describe varray?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
How to create a single index for multiple columns?
What is a directory object?
8. Display the client name and order date for all orders using the natural join keywords.
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
Oracle General 
