Referencing PL/SQL TABLE's record??

From: <agi_at_mail.taicom.com.tw>
Date: Fri, 09 Jul 1999 07:56:07 GMT
Message-ID: <7m49uk$4iv$1_at_nnrp1.deja.com>

[Quoted] Hi,theres

   I declare a PL/SQL TABLE based on a cursor, how to reference    the PL/SQL table to retrieve the record that I want ??    some code in my procedure as follows

   cursor ccy is select a,b,c

                    from table_A
        	   where a = xxx;

   type cur_table is table of ccy%rowtype index by binary_integer;    ccy_tab curcd_table;

   after transfering database info to pl/sql table,(if every record on    the pl/sql table is unique)

   how to referencing ccy_tab.c where ccy_tab.a ='AAA'??

   ccy_tab(idx).c is which I want,and ccy_tab.a ='AAA' is the condition.

Rgds,
Agi Chen

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 09 1999 - 09:56:07 CEST