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
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
what is power prompt in cognos ep7series?what is the use of this?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
write a query to display the departments with no employee?
What are all the types of gateway used in Cognos?
How to a create header dynamically in a crosstab report in cognos 8.1?
How to test a cube?
Why cognos scenario is used?
what is the difference between list report and crosstab report?
What junk dimension contains?
in u r data u having duplicates how to fetch the latest data in our report?
Can you define framework manager?
What are the steps to import the two data sources in framework manager?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
--------------Explain Table of contents?