Interested to Buy Any Domain ? << Click Here >> for more details...
What is a view? Why use it?
- 2 Answers
- 7976 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 |
Explain about dbrm.
Do we need cursor for Count(*)?
What is dbrm? When it will be created?
How do I import a csv file into db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is db2 purescale?
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 do you mean by commit and rollback?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
Can any one tell me about Restart logic in DB2.
What is a synonym? How is it used?
Explain how can you do the explain of a dynamic sql statement?
COBOL 
