A cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows the cursor holds is referred to as the active set. You can name a cursor so that it could be referred to in aContinue reading “Cursors in pl sql”
Category Archives: SQL
Basics of Sql
Section 1. Querying data This section helps you learn how to query data from the SQL Server database. We will start with a simple query that allows you to retrieve data from a single table. SELECT– show you how to query data against a single table. Section 2. Sorting data ORDER BY– sort the resultContinue reading “Basics of Sql”
plsqlonlinetraining 