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

What is relationship? How many types of relationship are there?

1149


What is sqlexception in java?

966


What is cartesian join in sql?

1097


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1044


What is file based approach?

924


what happens if null values are involved in expressions? : Sql dba

1026


how to calculate expressions with sql statements? : Sql dba

1023


What is %type in sql?

947


What is compiled query?

1014


What is the difference between sql and isql*plus?

1070


What is data type in sql?

941


What is sqlcommand?

1008


How do I delete a trigger?

944


What are the different sql languages?

1022


What is procedure and function in sql?

971