select * from orders where odate between '2010-01-01'and
'2010-03-31' How do u fetch this into cursor?
Answers were Sorted based on User's Feedback
Answer / muneer
Declare orders_cur cursor
for
select * from orders where odate between '2010-01-01'and
'2010-03-31'.
Open orders_cur
fetch orders_cur....
Hi friends i think that will the procedure ...if any mistake
suggest me
Is This Answer Correct ? | 4 Yes | 0 No |
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
How can you get the number of rows impacted by the last executed query?
What is the maximum size of varchar data type in db2?
What is dpf in db2?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What is dclgen in db2?
Mention data types used in db2 ?
What can the Locate option of the Repair Utility accomplish?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What does a deadlock mean in DB2?
What are the bind parameters ibm db2?
What is Skeleton cursor table (SKCT)?