what is view? types of views?
Answers were Sorted based on User's Feedback
Answer / k naveen kumar
View is mirror image to the base table(main table) i,e it is
a logical pointer to the base table.
for the view it does not occupy space for the data but it
occupy space for the structure
Two types of views
1) simple 2) complex view
simple view created on single table
complex view created on multiple tables.
Is This Answer Correct ? | 3 Yes | 0 No |
A view is a tailored presentation of the data.contained in
one or more tables or other view.it takes the o/p of a
query and treat it as a table. it does n't require any
space in database.
ex.create view emp1 as select empno,empname from emp;
types of view:Materialised view.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / arkchowdary
A view is, in essence, a virtual table. It does not
physically exist. Rather, it is created by a query joining
one or more tables.
Creating a VIEW
The syntax for creating a VIEW is:
CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;
Is This Answer Correct ? | 0 Yes | 0 No |
What is use of Field Set present in toolbox?
what use of surgate key in project
I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?
Define report item?
How to select all in value prompt instead of cascade prompt?
WHAT ARE THE TYPES OF LIST REPORTS?
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
What do you understand by the term 'model durability'?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
Cleared COG-112 with 100% score today. What next certification should i go for?
hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd
What is metric store database?