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
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..
Give me any example of semi and non additive measures?
What are the different uses of a repository manager?
What is Fullouterjoin?
What do you understand by the term 'aggregate cache'?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What do you understand by the cognos?
Define metrics studio?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What is called cognos reporting tool?
What is difference between content store and content manager?
What are the components of report net?
What are the different types of reports present in cognos?
Define the slice and dice?