Interested to Buy Any Domain ? << Click Here >> for more details...
Can a View based on another View ?
- 3 Answers
- 11810 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 transaction control statement and how many types of transaction control statement in Oracle?
What is Database Trigger ?
How to execute a stored program unit?
How to get a create statement for an existing table?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
What do you understand by a database object?
What is the difference between truncate & delete command?
what is foreign key?
what are the differen between key flexifild and discriptive fiexifild.
How to fetch the row which has the max value for a column?
Explain the characteristics of oracle dba?
What is a Database instance ? Explain?
Oracle General 
