What is the Difference between Implicit and Explicit cursor ?
Can some body pls explain me difference between Implicit and Explicit Cursor in SQL Server2008 with example
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Sep 16, 2011, 3:58 PM
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