suresh Sure! In PL/SQL, the focus keyword here is "cursor vs cursor variable."
In PL/SQL, a cursor is a named private SQL area from which information can be fetched. It is like a pointer that points to the results of a SQL query. Cursors are used to process individual rows returned by a query.
On the other hand, a cursor variable is a variable that points to a cursor result set from a query. Unlike regular cursors, cursor variables are not tied to a specific query at compile time. They can be dynamically opened and closed and can point to different result sets at runtime, providing more flexibility in handling query results.
In summary, a cursor in PL/SQL is a specific query result set that you can manipulate row by row, while a cursor variable is a reference to a query result set that provides more dynamic control over the result set being processed.
Please login or Register to submit your answer