PL-SQL: variable column processing

From: Carsten Wagener <carsten_wagener_at_yahoo.com>
Date: Tue, 22 Sep 1998 15:19:56 +0200
Message-ID: <3607A3FC.638375C8_at_yahoo.com>



Hi,
[Quoted] maybe a stupid question:

Table xx contains 5 columns (a,b,c,d,e).

I'd like to read each row and for each column of it I'd like to call the same procedure.

 I don't want to do it like this (that's stupid if there are hundrets of coluns):

doit(xx.a);
doit(xx.b);
doit(xx.c);
doit(xx.d);
doit(xx.e);

I like to do it like this:
loop
  doit(yy)
endloop

Thanks for any hints
Carsten Received on Tue Sep 22 1998 - 15:19:56 CEST

Original text of this message