why we create view.
- 5 Answers
- 9240 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / wazid noor mohammed
sometimes u have to write complex queries.
for this query u can give one name.
For to give that name we use view concept.
after defining the view with the particular name to the
complex query.
Next time ,we can execute that query by simply calling the
view name of that query
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / om prakash yadav
Provide the Security and see the part of data.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / vinay
to ristrict the full access of table data... to users or
group of users
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / om yadav
the reasons why view are created are:
1. When data security is required.
2. When data redundancy is to be kept to the minimum while
maintaining data security.
| Is This Answer Correct ? | 5 Yes | 2 No |
What is db2 optimizer?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is a composite index and how does it differ from a multiple index?
What is cursor with hold option in db2?
What is a recovery log?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Why cursor is used in db2?
What is query for your birthday date should be in hours,minute and seconds format?
How would you print the output of an SQL statement from SPUFI?
What is the role of the data page in the db2 database?
What can the Locate option of the Repair Utility accomplish?
Where is the access path logic created by the DB2 Optimizer stored?
COBOL 
