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
What is multi row fetch in db2?
What is the syntax for FETCH in DB2 ?
How does coalesce work?
What is syscat in db2?
How to check sequence on a table in db2?
How do I optimize a query in db2?
What kind of database is db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is db2 plan table?
What is the latest version of ibm db2?
What is buffer pool and list some of them?
How can record locking be achieved in those DB2 versions which do not support it?
What are the uses of db2 optimizer?
How do we specify index to include or not during bind process.
How do I delete a table in db2?