Information About Cursor

    Information About Cursor

CURSOR:=
CURSOR IS POINTER TO THE MEMORY LOCATION WHERE THE INFORMATION ABOUT SQL STMT OR DML STATEMENT GOT EXECUTED.

EMPLICIT CURSOR:=
ANY SELECT STMT OR ANY SQL STMT EXECUTED BY ORACLE IS THROUGH CURSOR AND USER DONT HAVE CONTROLED ON IMPLICIT CURSOR BUT USE CAN GET INFORMATION FROM ITS ATTRIBUTES THAT IS CALLED EMPLICIT CURSOR . ONLY IN OTHER WORDS
ORACLE AUTOMATICLAY OPEN THE MEMORY ALLOCATION EXECUTE THE STMT AND RETURN THE RESULT AND CLOSES THE MEMORY ALLOCATION CALLED EMPLICIT CURSOR.

EXPLICIT CURSOR:=
WHERE AS WHEN USER GIVES NAME FOR THAT MEMORY ALLOCATION AND HE IS TRYING TO ACCESS THE MEMORY ALLOCATION ONE BY ONE ONCE HE ACCESS THE ENTIRE INFORMATION AND IF DEVELOPER CLOSES THE MEMORY ALLOCATION THAT IS CALLED EXPLICIT CURSOR. IS IS FULLY MANAGED BY DEVELOPER.

CURSOR ATTRIBUTES:=

 IS THE WAY BY WHICH WE CAN GET THE INFORMATION OR RUN TIME INFORMATION ABOUT THE CURSOR CALLED CURSOR ATTRIBUTES.

PARAMETERIZED CURSOR:=

REUSEBILITY OF THE SAME CURSOR OF THE MULTIPLE PLACESS , IF YOU WANT TO USE SAME SELECT STATEMENT IN MULTIPLE CASES WHARE THERE IS JUST DIFFERECE BETWEEN THE WHARE CONDITION YOU CAN GO AHEAD WITH THE PARAMETERIZED CURSOR.