Inserting updating records using pl sql cursor

By extending SQL, PL/SQL offers a unique combination of power and ease of use.You can manipulate Oracle data flexibly and safely because PL/SQL fully supports all SQL data manipulation statements (except ), transaction control statements, functions, pseudocolumns, and operators.In this chapter, we will discuss the cursors in PL/SQL. A cursor holds the rows (one or more) returned by a SQL statement.

inserting updating records using pl sql cursor-55inserting updating records using pl sql cursor-59inserting updating records using pl sql cursor-34inserting updating records using pl sql cursor-61

It is important not to allow one operation to succeed while the other fails.

For INSERT operations, the cursor holds the data that needs to be inserted.

For UPDATE and DELETE operations, the cursor identifies the rows that would be affected.

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.

Leave a Reply