But you can do them against PL/SQL table collections
(using TABLE and CAST) which may be useful here
hth
connor
- Christopher Spence <cspence_at_FuelSpot.com> wrote:
> You cannot use SQL against PL/SQL tables.
>
> "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."
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax: (707) 885-2275
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
> -----Original Message-----
> Sent: Wednesday, October 03, 2001 12:26 PM
> To: Multiple recipients of list ORACLE-L
>
> 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
> .
> declare
> type 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;
> begin
> open r;
> loop
> FETCH 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
> */
> end;
> If there is any alternative for intermediate table
> let me know.
> thanx in advance
> shishir kumar mishra
> shishir_at_agnisoft.com <mailto:shishir_at_agnisoft.com>
>
>
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Oct 03 2001 - 12:47:21 CDT
