Can a View based on another View ?
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 |
Explain the dml?
What is the difference between formal parameters and actual parameters?
Can we create more than one index on particular column?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What is a relational database management system?
How to start a new transaction in oracle?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
difference between oracle8i and oracle9i
Youre getting high busy buffer waits - how can you find whats causing it?
How to assign values to data fields in record variables?