Oracle updating records within same cursor


Then, you can declare a record based on record type that you’ve defined.

Cursor FOR Loops and Implicitly Declared Records Suppose I want to write a program to display the last names of all employees.

An elegant and simple way to do this in PL/SQL is to take advantage of the cursor FOR loop (which I discussed in part 2 of this PL/SQL 101 series).

User-defined records offer the flexibility to construct your own composite datatype, reflecting program-specific requirements that may not be represented by a relational table.

In the next article in this PL/SQL 101 series, I will explore another key composite datatype, the collection.

Search for oracle updating records within same cursor:

oracle updating records within same cursor-78

PL/SQL offers special syntax in both the INSERT and UPDATE statements so that you can easily use records to perform those data manipulation language (DML) operations as well.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “oracle updating records within same cursor”