Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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?

963


what is power prompt in cognos ep7series?what is the use of this?

3689


what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

1088


write a query to display the departments with no employee?

1971


What are all the types of gateway used in Cognos?

1029


How to a create header dynamically in a crosstab report in cognos 8.1?

2439


How to test a cube?

2190


Why cognos scenario is used?

1062


what is the difference between list report and crosstab report?

1181


What junk dimension contains?

992


in u r data u having duplicates how to fetch the latest data in our report?

5731


Can you define framework manager?

1027


What are the steps to import the two data sources in framework manager?

1048


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2068


--------------Explain Table of contents?

2020