A REF CURSOR have a return type and it as 2 type Strongly Typed Cursor and Weakly Typed Cursor
but Cursor doesn't have return type
Ex:
TYPE ref_type_name IS REF CURSOR RETURN return_type;
return_type represents a record in the database
DECLARE TYPE EmpCurType IS REF CURSOR RETURN emp%ROWTYPE;
***********************************
Cursor doesn't have a return type but
A Reference Cursor have a return type and it as 2 type one is
Strongly Typed Cursor and Weakly Typed Cursor.
**************************************************
ref cursor can be associated with many no. of sql statements where cursor can be associated only with one sql statement.
ref cursor is dynamic,cursor is static.
ref cursor points to a location.