![]() ![]() 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 |