what is view? types of views?

Answer Posted / arangaraj

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2143


How can we Maintain the Cube Security by Category level and Dimension level ?

1957


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1873


What are the components used in web tier?

539


hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

1943






Can you define a datastore in cognos?

611


how to test reports in cognos?

591


Is it possible to join multiple Databases in a Catalog?

642


What is the difference between Open Connection command ang Open Session Command?

1922


what is the role of cognos comsultant?what actually it means?pls reply

1883


Can you explain cognos planning?

667


What do you mean by query studio?

515


What are the components of report net?

737


What is Fullouterjoin?

1554


Why need staging area database for dwh?

646