Interested to Buy Any Domain ? << Click Here >> for more details...
Can a View based on another View ?
- 3 Answers
- 11801 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 |
Without giving condition how to retrieve the unmatched records from table.
Why does for update in oracle 8 cause an ora-01002 error?
What is the meaning of recursive hints in oracle?
How to define an oracle sub procedure?
What is currency type in database ?
Can we create more than one constraint to column ?
Explain integrity constraint?
Explain integrity constraints?
how to retrieve data from different tables ,place this data in different excel worksheets.
How to use like conditions in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to view all columns in an existing table?
Oracle General 
