Cursor FOR LOOP - SQL Snipplr Social Repository

Revision: 31498

at September 8, 2010 02:21 by mprabhuram

Initial Code

CREATE OR REPLACE Function TotalIncome
    ( name_in IN varchar2 )
    RETURN varchar2
IS
    total_val number(6);

    cursor c1 is
      select monthly_income
      from employees
      where name = name_in;

BEGIN

total_val := 0;

FOR employee_rec in c1
LOOP
    total_val := total_val + employee_rec.monthly_income;
END LOOP;

RETURN total_val;

END;

Initial URL

http://www.techonthenet.com/oracle/loops/cursor_for.php

Initial Description

You would use a CURSOR FOR Loop when you want to fetch and process every record in a cursor. The CURSOR FOR Loop will terminate when all of the records in the cursor have been fetched.

Initial Title

Cursor FOR LOOP

Initial Tags

Oracle

Initial Language

SQL

Choose a language for easy browsing: