why we create view.
- 5 Answers
- 10462 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 reorg in DB2
What are data types?
What are foreign keys?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
How does the processing of a correlated subquery differ from a non correlated subquery?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is explain in db2?
What is the meaning concurrency in the db2 database?
What is copy book?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
COBOL 
