What is plsql cursor

If the cursor declaration declares parameters, each parameter must be used in the query. You must declare a variable before referencing it in a cursor declaration. You cannot assign values to a cursor name or use it in an expression. However, cursors and variables follow the same scoping rules. You retrieve data from a cursor by opening it, then fetching from it. The scope of cursor parameters is local to the cursor, meaning that they can be referenced only within the query used in the cursor declaration.

The values of cursor parameters are used by the associated query when the cursor is opened. The datatype of a cursor parameter must be specified without constraints, that is, without precision and scale for numbers, and without length for strings. Cursors To execute a multi-row query, Oracle opens an unnamed work area that stores processing information. Improve Article. Like Article. Recommended Articles. Article Contributed By :. Easy Normal Medium Hard Expert. Writing code in comment? Please use ide.

Load Comments. Previous Page. Next Page. Previous Page Print Page. Save Close. Dashboard Logout.