What is the Difference between Implicit and Explicit cursor ?

Question

Can some body pls explain me difference between Implicit and Explicit Cursor in SQL Server2008 with example

Satyapriya Nayak · Answer

Hi Syed Implicit cursor:- means predefine cursor. Its attributes starting with the sign % like that %ROWCOUNT %ISOPEN etc. Explicit cursor:- means created by the user or programmer. Its attributes starting with the cursor name then % sign like that cursorname%ROWCOUNT cursorname%ISOPEN etc. For more details Please refer the below link http://www.javaplsql.com/plsql-interview-questions/what-is-the-difference-between-implicit-and-explicit-cursors Thanks