RE: intermediate table

Try using temporary
tables. You can then carry out formating. Using selects is not possible on pl/sql tables, if that is what you're using. rgds <FONT face=Courier
color=#000000 size=2>amar
 

  <FONT face="Times New Roman"
  size=2>-----Original Message-----From: Shishir   [mailto:shishir_at_agnisoft.com]Sent: Wednesday, October 03, 2001 8:26   PMTo: Multiple recipients of list ORACLE-LSubject:   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   color=#000000>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 Thu Oct 04 2001 - 09:18:35 CDT