Dynamic cursor Ref Cursor or Cursor Variable.

Dynamic cursor Ref Cursor or Cursor Variable:

• Explicit cursor is Static Cursor.
• Explicit cursor referrers always one work area associated with cursor.
• Dynamic cursor is Ref Cursor, It referrers different work area in memory.
• Cursor variables are analogous to PL/SQL variables, which can hold different values at runtime.
• It is used to declare a cursor with out select statement.
• A Ref Cursor can be reused if it is declared in package.
• A Ref Cursor support to return more than 1 row from sub program.
• Deferent select statement can be associated with cursor variable at run time.