## "Explicit" verses "Implicit" SQL cursors

    DECLARE 
    CURSOR C IS 
    SELECT     EMP_NAME
        FROM   EMP
        WHERE  EMP_NO = 1234;

    BEGIN
        OPEN  C;
        FETCH C INTO . . . ;
        CLOSE C;
    END;


##  An explicit cursor would look like :

    SELECT EMP_NAME
    INTO  :EMP_NAME
    FROM   EMP
    WHERE  EMP_NO = 1234;