Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can a View based on another View ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the execution control statements?

1068


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309


What is index in Oracle?

1074


Point out the difference between user tables and data dictionary?

985


Explain the use of analyse option in exp command.

1128


is there a tool to trace queries, like profiler for sql server?

1142


How view is different from a table?

1040


How to join two tables in a single query using oracle?

997


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007


Explain self joins in oracle?

1023


What is PL/SQL ?

2076


query optmization techniques and quwry analyser+projects+ppts

2422


What is a cursor and what are the steps need to be taken?

1202


How to change program global area (pga) in oracle?

1096


Explain the use of online redo log files in oracle.

1038