intermediate table

Hi to all !
I have one small problem and i am sure many of u can reply .My problem is :i am storing data from different table into   intermediate table but the

i want to use sql statements to filter data from that intermediate table, I can access it as array of user defined object . but i want to use sql statement for extracting the data so plz help me out.
the below code is just prototype,not actual one whoch is only one table TAX .

declaretype my_rec_type is record (c1
tax.col_lbl%type,c2 tax.subj_carr%type);type my_plsql_table_type is table of my_rec_type index by binary_integer;v_table my_plsql_table_type;rec my_rec_type ;num number;cursor r is select rownum, col_lbl, subj_carr from tax;beginopen r;loopFETCH r INTO num ,rec.c1,rec.c2;
EXIT WHEN r%NOTFOUND;v_table(num).c1 := rec.c1;v_table(num).c2 := rec.c2;end
loop;/* I want to
use sql statements for fetch record like select rowi from v_table where condition =conditionname*/<FONT
size=2>end;
If  there is any alternative for intermediate table let me know. thanx in
advance
shishir kumar mishra<A
href="mailto:shishir_at_agnisoft.com">shishir_at_agnisoft.com   Received on Wed Oct 03 2001 - 10:38:41 CDT