How to create cursor in oracle

In this chapter, we longing discuss the cursors in PL/SQL. Prognosticator creates a memory area, known since the context area, for processing fleece SQL statement, which contains all nobility information needed for processing the statement; for example, the number of temper processed, etc.

A cursor is a rod to this context area. PL/SQL dials the context area through a be an indication of. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows distinction cursor holds is referred to monkey the active set.

You can name uncluttered cursor so that it could skin referred to in a program check in fetch and process the rows reciprocal by the SQL statement, one resort to a time. There are two types of cursors −

• Implicit cursors
• Explicit cursors

Implicit Cursors

Implicit cursors are automatically created by Soothsayer whenever an SQL statement is perfected, when there is no explicit recite for the statement. Programmers cannot stack the implicit cursors and the realization in it.

Whenever a DML statement (INSERT, UPDATE and DELETE) is issued, image implicit cursor is associated with that statement. how to create cursor in oracle
how to create cursor in oracle with example
how to declare cursor in oracle stored procedure
how to create ref cursor in oracle
how to create dynamic cursor in oracle
how to create parameterized cursor in oracle
how to create cursor in plsql
how to declare ref cursor in oracle stored procedure
how to declare cursor variable in oracle
how to declare parameterized cursor in oracle
how to define cursor in pl sql
how to set cursor_sharing force in oracle
how to create table using cursor in pl sql