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...

What are the advantages of VIEW?

Answer Posted / anil_abbireddy

1. data security : complex view can not be modified ie.
base tables cannot be visible.
2. it provides easy way to query data from different data
sources like a single table
3.it is very usefull when developing complex reports basing
on multiple tables.

Is This Answer Correct ?    38 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Show how functions and procedures are called in a pl/sql block.

1127


What is a .db file?

986


What is mutating error?

968


explain advantages of innodb over myisam. : Sql dba

1130


What is procedure and function in sql?

1001


Why do we use triggers?

968


How many types of relationship are there?

1031


Do we need to create index on primary key?

929


How do I create an index in word?

1034


How do you use a while loop in pl sql?

1014


What will you get by the cursor attribute sql%found?

963


How does sql store data?

921


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1227


what does the t-sql command ident_incr does? : Transact sql

1078


What is the use of pl/sql table?

1067