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 a Conformed Dimension?
Is it possible to join multiple Databases in a Catalog?
What is slowely changing dimensions?why we are used SCD?
What is the use of Excel files in Cognos8?
How many number of cubes can we create on a single model? How can we navigate between those cubes?
What is Merging, Segments and porting in Framwork Manager?
How to create measures and Demensions?
what are the errors faced while bursting the reports and how to solve those errors?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What are products of cognos?
how can you get the errors in job? when loops are araised we get error?
what is stitch query in reportnet?