Cursors pl sql updating Sex chat on my mobile

Rated 3.83/5 based on 829 customer reviews

When you fetch a row the current row position moves to next row.

is a name assigned to a specific private SQL area for a specific SQL statement.

Explicit Cursor which are construct/manage by user itself call explicit cursor.

User itself to declare the cursor, open cursor to reserve the memory and populate data, fetch the records from the active data set one at a time, apply logic and last close the cursor.

The set of rows the cursor holds is called the set.Use OPEN, FETCH, and CLOSE in the execution or exception sections of your programs.To use an explicit cursor, you must first declare it in the declaration section of a block or package.These static cursors can be explicitly declared and named or may appear in-line as an implicit cursor.Dynamic cursors are used for any type of valid SQL statement including DDL (CREATE, TRUNCATE, ALTER) and DCL (GRANT, REVOKE).

Leave a Reply