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

Is db2 relational database?

724


What is the cobol picture clause of the db2 data types date, time, timestamp?

827


What kind of database is db2?

763


What is plan in cobol db2?

779


What is the difference between drop table and delete table?

766


Can we update view in db2?

749


What action db2 takes when a program aborts in the middle of a transaction?

862


What is innodb buffer pool?

732


What is meant by union and union all?

774


How to access db2 tables in mainframe?

786


How do I optimize a query in db2?

807


Is ibm db2 free?

748


Why do we use cursor?

779


How is the value function used?

815


Mention the downsides of page level lock.

905