A

Admin • 833.24K Points
Coach

Q. Which statements are used to control a cursor variable?

  • (A) OPEN-FOR
  • (B) FETCH
  • (C) CLOSE
  • (D) All mentioned above
  • Correct Answer - Option(D)
  • Views: 29
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

There are three statements used to control a cursor variable:
1. OPEN-FOR - open a cursor variable for multi-row query
2. FETCH - it fetches the rows for the result set
3. CLOSE - when all the rows are processed the cursor variable is closed.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.