open/fetch/close cursor ] pl/sql, part 1

Lesson 1: open/fetch/close
Lesson 2: declare / open / fetch /close
declare the cursor

Lesson 3: open / fetch..into / close

  open cursor3;
  fetch cursor3 into record_var2;
  -- do something with record_var2
  close cursor3;

Lesson 4: declare / %ROWTYPE / open / fetch..into / close
After declaring the cursor, you declare a record-var to hold one row of data

  DECLARE
    CURSOR cursor3 IS SELECT ....
    record_var2 cursor3%ROWTYPE ;