Interested to Buy Any Domain ? << Click Here >> for more details...
What is a view? Why use it?
- 2 Answers
- 7974 Views
- I also Faced
- E-Mail Answers
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 |
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
How does DB2 use multiple table indexes?
What is buffer pool?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
In which column of which DB2 catalog would you find the length of the rows for all tables?
how can i pull up a query which was previously stored in qmf
where can we use index and subscript ? with example ?
List out the three types of page locks that can be held.
what is the difference between declaring the cursor in WS section and Procedure division?
Return code 100 means?
How to check table size in db2 sap?
COBOL 
