🔄 Cursors
Explicit cursors, FOR loops and fetch patterns for row-by-row work.
| Snippet | |
|---|---|
| ☆DECLARE CURSOR — Declare an explicit cursor |
CURSOR c_emp IS SELECT * FROM employees;
|
| ☆OPEN / FETCH / CLOSE — Manual cursor lifecycle |
OPEN c1; FETCH c1 INTO var1; CLOSE c1;
|
| ☆FOR LOOP — Cursor FOR loop (auto open/fetch/close) |
FOR rec IN c_emp LOOP DBMS_OUTPUT.PUT_LINE(rec.name); END LOOP;
|