Duration: 17:16 min
Summary: The Oracle database uses the SQL language to handle data. This language is based on the manipulations of set or rows in a very fast way and the general recommendation is that developers create solutions based on that set parading. However, sometimes it is needed to create a row-by-row processing with the data that is stored inside a table. In order to address this need the Oracle PL/SQL language provides cursors that get the data from a SELECT statement and allow the developer to read and write one row at the time. This video shows how to create, open, manipulate and close implicit and explicit cursor inside a PL/SQL block to perform row-based operations. The video contains example cursors that are created with the same datatypes of the table’s columns and store many rows as needed.