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:
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