PL/SQL basics

 
First, you need to learn the easiest things. This lesson is an introduction to PL/SQL language: you will create tables, insert data, write first blocks, declare variables and use them in code, learn loops and conditional instructions, etc.
 

PL/SQL Video Tutorial For Beginners

 

Cursors

 
In this lesson, you will learn how to use PL/SQL cursors. A cursor is an object pointer to a private SQL area that stores information coming from a SELECT or data manipulation language query (INSERT, UPDATE, DELETE, or MERGE). A cursor holds the rows (one or more) returned by a SQL statement.