Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL question...
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