Hack sex chat site - Inserting updating records using pl sql cursor

by  |  14-Oct-2014 07:50

The SELECT FOR UPDATE statement allows you to lock the records in the cursor result set.

You are not required to make changes to the records in order to use this statement.

The record locks are released when the next commit or rollback statement is issued.

inserting updating records using pl sql cursor-52

A cursor holds the rows (one or more) returned by a SQL 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.

There are two types of cursors: Implicit cursors are automatically created by Oracle whenever an SQL statement is executed, when there is no explicit cursor for the statement.

Programmers cannot control the implicit cursors and the information in it.

Whenever a DML statement (INSERT, UPDATE and DELETE) is issued, an implicit cursor is associated with this statement.

Community Discussion