Interested to Buy Any Domain ? << Click Here >> for more details...
What is a view? Why use it?
- 2 Answers
- 7848 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 |
What is the purpose of the DSNC transaction ?
Which component is responsible for db2 startup and shutdown?
how to resolve -818 error. how to see timestamp token in load module and plan
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is db2 bind?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is the role of union all and union
how to execute qcmdexc in rpgle?plz write code also?
what is differnece between DROP TABLE & DELETE TABLE .
What will the FREE command do to a plan?
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
What do you need to do before you do EXPLAIN?
COBOL 
