Re: What is the fastest/easiest way to find a row in a PL/SQL table

Rod J. Stewart doodled thusly:

>
>The table is populated via a cursor. My question is, what is the
>fastest performing way of locating a row in the table based on a
>supplied varchar2 value? Do I have to loop through each row of the

populate via cursor with an order by on the varchar2 value and do a binary search?

IIRC there is a way of doing this via direct SQL, but you must not use a INDEX BY table.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Tue Feb 12 2002 - 04:50:31 CST