Thread: Difference between Table, View and Synonym?

Originally Posted by kolisetty

Good morning everybody,

what is the difference between cursor and ref cursor? In which circumstances we use these both and how to use?

thankyou.

When you say cursor, u mean explicit cursor or cursor variable.
cursor(explicit cursor)- it is used to point select query in sql work area
and
ref cursor it is an explicit cursor which has been defined in standard package.
For more details: search devinline pl/SQl and read in more details. (Not able to post url.)

it has something to do with SQL