scoodels

• Feb 23rd, 2006

 

REF cursors are different than your typical, standard cursors. With standard cursors, you know the cursor's query ahead of time. With REF cursors, you do not have to know the query ahead of time. With REF Cursors, you can build the cursor on the fly

Nagesh

• Feb 28th, 2006

 

Normal Cursor is a Static Cursor.

Refernce Cursor is used to create dynamic cursor.

There are two types of Ref Cursors:

1. Weak cursor and 2.Strong cursor

 Type ref_name is Ref cursor [return type]

[return type] means %Rowtype

if Return type is mentioned then it is Strong cursor else weak cursor

The Reference cursor does not support For update clause.

Nantha

• Apr 18th, 2006

 

Normal cursor is used to process more than one record in plsql.

Refcusor is a type which is going to hold set of records which can be sent out through the procedure or function out variables.

syed_ansar

• Oct 18th, 2006

 

we can use Ref cursor as an IN OUT parameter .

Habib Ali

• May 10th, 2016

 

Normal Cursor > Your SELECT Query is determined already before BEGIN i.e. Table, Column Names
Ref Cursor > Your SELECT Query is determined at runtime after BEGIN i.e.Table, Column Names