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 |
What is the oracle implicit cursor?
How to turn on or off recycle bin for the session?
Can we commit inside a function in oracle?
How to get a list of all tables in the database?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is the difference between formal parameters and actual parameters?
What are the different editions of oracle?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
How to define an external table with a text file?
What is the sql query to concatenate column values from multiple rows in oracle?
How to get a create statement for an existing table?