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

why we create view.

Answer Posted / as

I know a senario in which views are created.

Suppose I have a field in my table which is secure and
should not be visible to everyone. In that case i can
create a view without that field and keep the table acces
(even browse) with a particular set of people.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain correlated sub-queries.

1036


What is the max length of sqlca?

1219


What is the difference between cursor stability and repeatable read isolation levels?

1182


What does db2 stand for?

1033


What is an instance database?

1057


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9220


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11679


What is sqlca’s maximum length?

1195


What is the role of schema in the db2 database?

1278


List down the types of triggers in the db2 database?

1035


What's The Error Code For Unique Index Voilation?

1242


How do I delete a table in database?

1027


What are the various isolation levels possible?

1122


How to get the ddl of a table in db2?

1132


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2068