Re: Problem with SQL

From: clarkr1 <clarkr1_at_aol.comxb8qp3>
Date: 13 Mar 1999 20:35:37 GMT
Message-ID: <19990313153537.24197.00000304@ngol05.aol.com>

I am not sure but you might be able to do this with PL/SQL such as:

DECLARE
    CURSOR cur IS

        SELECT name, no_1, no_2 FROM table;

    my_name  CHAR(10);
    my_no1  NUMBER(4);
    my_no2    NUMBER(7,2);

BEGIN
    OPEN cur;
    LOOP

	FETCH cur INTO my_name, my_no1, my_no2;
	EXIT WHEN (cur%ROWCOUNT > 15) OR (cur%NOTFOUND);
	INSERT INTO temp VALUES (my_no1, my_no2, my_name);
        COMMIT;

    END LOOP;
    CLOSE cur;
END; Received on Sat Mar 13 1999 - 14:35:37 CST