While updating records using cursor
It is a general concept that encompasses lists, arrays, and other datatypes used in classic programming algorithms. A record is a group of related data items stored in fields, each with its own name and datatype.
as an integer, and make it an identifier column by checking the identity box in the table design window.
You can pass collection variables as parameters to stored subprograms.
To look up data that is more complex than single values, you can store PL/SQL records or SQL object types in collections.
When there is more than one row in a cursor we can use loops along with explicit cursor attributes to fetch all the records.
Points to remember while fetching a row: · We can fetch the rows in a cursor to a PL/SQL Record or a list of variables created in the PL/SQL Block.