Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL question...

PL/SQL question...

From: Scott MacLennan <smaclennan_at_nospam.ism.ca>
Date: Wed, 27 May 1998 15:14:44 GMT
Message-ID: <356c2c5b.3791792@news.mts.net>


Ok,

If I need to loop through each column (each of which is an attribute), how can I substitute a string for the column name in a function? It works for COUNT(v_attribute) but not for MIN(v_attribute)...

Here's an eg.
declare

        v_attribute varchar2(10);

BEGIN
v_attribute:='age';

select count(v_attribute) into v_temp from big_table; <==WORKS

select min(v_attribute) into v_temp from big_table; <== Nope END; Thanks... Received on Wed May 27 1998 - 10:14:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US