Can You Tell Me What Will Happen When You Say Open Cursor?

1.	Can You Tell Me What Will Happen When You Say Open Cursor?
Answer» If there is an ORDER BY clause, rows are fetched, sorted and MADE available for the FETCH statement Other wise simply the cursor is placed on the first ROW. If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement Other wise simply the cursor is placed on the first row.

Answer»

If there is an ORDER BY clause, rows are fetched, sorted and MADE available for the FETCH statement Other wise simply the cursor is placed on the first ROW.

If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement Other wise simply the cursor is placed on the first row.

Discussion

No Comment Found

Related InterviewSolutions

Explain What Are The Disadvantages Of Page Level Lock In Db2?
Explain In Brief How Does Db2 Determine What Lock-size To Use?
Name The Various Locking Levels Available?
When Do You Specify The Isolation Level?
Differentiate Between Cs And Rr Isolation Levels?where Do You Specify Them?
Explain What Are The Various Isolation Levels Possible ?
Explain How Can You Do The Explain Of A Dynamic Sql Statement?
What Does It Mean - Explain Has Output With Matchcols = 0?
Can You Tell Where Is The Output Of Explain Stored?
Can You Tell What Do You Need To Do Before You Do Explain?

Can You Tell Me What Will Happen When You Say Open Cursor?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment