RE: intermediate table

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>You cannot use SQL against PL/SQL tables.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:12.0pt;

color:navy;mso-no-proof:yes'>"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

<span style='font-size:18.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Christopher R. Spence<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Oracle DBA<span style='color:navy;
mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Phone: (978) 322-5744<span
style='color:navy;mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Fax:    (707) 885-2275<span
style='color:navy;mso-no-proof:yes'>

<span style='font-size:10.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Fuelspot<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>73 Princeton Street<span style='color:navy; mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>North, Chelmsford 01863<span
style='color:navy;mso-no-proof:yes'>
 

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Shishir
[mailto:shishir_at_agnisoft.com]
Sent<span
style='font-weight:bold'>: Wednesday, October 03, 2001 12:26 PM To: Multiple recipients of list
ORACLE-L
Subject: intermediate table

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'>Hi to all !

<span

style='font-size:10.0pt;font-family:Arial'>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

<span

style='font-size:10.0pt;font-family:Arial'>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.

<span

style='font-size:10.0pt;font-family:Arial'>the below code is just prototype,not actual one whoch is only one table TAX .

<span

style='font-size:10.0pt;color:black;font-weight:bold'>declare<font size=2 color=black>
type my_rec_type <span
style='font-weight:bold'>is record
(c1 tax.col_lbl%type,c2
tax.subj_carr%type);
type my_plsql_table_type <span
style='font-weight:bold'>is table
of my_rec_type <span
style='font-weight:bold'>index by
binary_integer;
v_table my_plsql_table_type;
rec my_rec_type ;
num number;
cursor r <span
style='font-weight:bold'>is select
rownum, col_lbl, subj_carr from
tax;
begin
open r;
loop
FETCH r <span style='font-weight:
bold'>INTO num ,rec.c1,rec.c2;
EXIT <span style='font-weight:
bold'>WHEN r%NOTFOUND;
v_table(num).c1 := rec.c1;
v_table(num).c2 := rec.c2;
end <span style='font-weight:
bold'>loop;
<span style='font-size:10.0pt;

color:red;font-style:italic'>/* I want to use sql statements for fetch record like
select rowi from v_table
where condition =conditionname
*/
<span style='font-size:10.0pt;

color:black;font-weight:bold'>end<span
style='font-size:10.0pt;color:black'>;

<span

style='font-size:12.0pt'>If  there is any alternative for intermediate table let me know.

<span

style='font-size:10.0pt;font-family:Arial;color:black'>thanx in advance

<span

style='font-size:10.0pt;font-family:Arial;color:black'>shishir kumar mishra shishir_at_agnisoft.com

<span

style='font-size:12.0pt;color:black'>  Received on Wed Oct 03 2001 - 12:01:32 CDT