Programmers cannot control the implicit cursors and the information in it. Implicit cursors are automatically created by Oracle whenever an SQL statement is executed, when there is no explicit cursor for the statement. You can name a cursor so that it could be referred to in a program to fetch and process the rows returned by the SQL statement, one at a time. The set of rows the cursor holds is referred to as the active set. A cursor holds the rows (one or more) returned by a SQL statement. PL/SQL controls the context area through a cursor. Oracle creates a memory area, known as the context area, for processing an SQL statement, which contains all the information needed for processing the statement for example, the number of rows processed, etc.Ī cursor is a pointer to this context area. In this chapter, we will discuss the cursors in PL/SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |