Interested to Buy Any Domain ? << Click Here >> for more details...
When is the results table for the query in a DECLARE CURSOR
statement created?
- 5 Answers
- 9093 Views
- I also Faced
- E-Mail Answers
Answer Posted / mani
the first one is correct i.e. when the open cursor statement
gets executed, the results table is created for the query in
declare cursor statement.
after that when fetch is done it is actually retrieved one
by one from the results table.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the physical storage length of time data type?
What is dbrm? When it will be created?
How to find primary key of a table in db2?
Describe major components of db2?
What is dbrm library?
What is the clustering index in the db2 database?
What is a Foreign Key?
Can we insert update delete in view?
Is db2 free?
Is db2 a mainframe database?
What is a dbrm in db2?
What is innodb buffer pool?
What is rct?
What is ibm db2 connect?
