1.

Explain In Brief The Cursor Optimization Tips?

Answer»
  • Close cursor when it is not required.
  • You shouldn’t forget to deallocate cursor after closing it.
  • You should FETCH least NUMBER of RECORDS.
  • You should use FORWARD ONLY OPTION when there is no need to update rows.


Discussion

No Comment Found

Related InterviewSolutions