why we create view.

Answer Posted / wazid noor mohammed

sometimes u have to write complex queries.
for this query u can give one name.
For to give that name we use view concept.
after defining the view with the particular name to the
complex query.
Next time ,we can execute that query by simply calling the
view name of that query

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1575


What is package in cobol db2?

700


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2685


What is an instance database?

598


What is the difference between plan and package in db2?

569






What is meant by union and union all?

583


What is bind plan?

608


How to test SQL -911 error while developing COB-DB2 program

6708


What is sqlca?

618


What is db2 instance?

590


What is the default page size of buffer pools?

644


What is the syntax for FETCH in DB2 ?

672


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

706


What is the difference between cursor stability and repeatable read isolation levels?

678


What are the various data types available in db2?

630