What is a view? Why use it?
Answers were Sorted based on User's Feedback
Answer / babji009
A view is a virtual table made up of data from base
tables and other views, but not stored separately.
Ex:
CREATE VIEW GOOD1_SUPPLIERS
AS SELECT S#, STATUS, CITY
FROM S
WHERE STATUS > 15;
SELECT * FROM GOOD1_SUPPLIERS;
---------+---------+---------+---------+-----------
SELECT * FROM GOOD1_SUPPLIERS;
---------+---------+---------+---------+-----------
S# STATUS CITY
---------+---------+---------+---------+---
S3 40 PARIS
S4 110 LONDON
S8 30 ATHENS
S7 20 U.S.A
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / om yadav
after a table is created and populated with data, it may
become necessary to prevent all users from accessing all
column of a table, for data security reasons.
To reduce redundant data to the minimum possible, allows the
creation of an object called VIEW.
Define:= A VIEW is mapped , to a select sentence. The SELECT
clause consists of a sub-set of the columnb of the table.
thus a view , which is mapped to a table, will in effect
have a sub-set of the actual column of the table from which
it is bulit.
This technique offers a simple, effective way of hiding
column of the table.
Is This Answer Correct ? | 5 Yes | 0 No |
How do you run JCL in cobol program
How to define the data items to receive the fetch items for the SQL?
What is the role of the data page in the db2 database?
What is the database descriptor?
How to find primary key of a table in db2?
What is EXPLAIN?
What is a recovery log?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What does runstats do in db2?
where will u check for sqlcode ?
What is the difference between SYNONYM and ALIAS?
What is an instance database?