Oracle Cursor types?

Implicit Cursor: implicit cursor will make automatically by oracle system it open fetch and close it automatically. Implicit Cursor like SQL%rowcount, SQL%rowtype...

Explicit Cursor: Explicit cursors are user defined cursor. You have made it forcefully like:

Cursor C1 is select ename from emp;

Ref Cursor: Ref Cursor is object name of the cursor type. It’s mainly used for dynamic purpose.