a pl/sql question?

From: <yliu_at_creighton.edu>
Date: Wed, 8 Mar 2000 14:52:20 -0600
Message-ID: <Pine.HPP.3.95.1000308142938.17769A-100000@penguin.creighton.edu>

Hi All,

I was wondering if someone can tell me what the difference is between the following two pl/sql logics? To me, they are the same.

(1).

open c1;

     loop
      begin
	  fetch c1 into .... --- some variables
	  exit when c1%notfound;
	  insert into temp .... (the values of those variables)
      end;
     end loop;

close c1;

(2).

open c1;

     loop
      begin
           fetch c1 into .... --- some variables;
           exit when c1%notfound;
      end;
      begin
        insert into temp .... (the values of those variables)
      end;
     end loop;

close c1;

Thank you very much for your help.

Best Regards,

Yongge
yliu_at_creighton.edu Received on Wed Mar 08 2000 - 14:52:20 CST