what is view? types of views?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2261


Give me any example of semi and non additive measures?

568


What are the different uses of a repository manager?

609


What is Fullouterjoin?

1560


What do you understand by the term 'aggregate cache'?

581






Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

600


What do you understand by the cognos?

552


Define metrics studio?

589


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

5993


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10769


What is called cognos reporting tool?

608


What is difference between content store and content manager?

556


What are the components of report net?

744


What are the different types of reports present in cognos?

580


Define the slice and dice?

581