Re: Binary or Hash search in plsql table

From: Sunil <sunil_franklin_at_hotmail.com>
Date: Wed, 10 Apr 2002 19:24:15 +0530
Message-ID: <PvXs8.18$U23.79@news.oracle.com>

The pl/sql table holds varchar2 values.

The cursor returns a long column from a database table.

It is a substring match.

Thanks,
Sunil.

"Jonathan Lewis" >
> Just to clarify the situation -
>
> The pl/sql table holds about 100 'long' values.
>
> The cursor returns a long column from
> about 10,000 rows, and you want to match
> these up against the table.
>
> Is this correct ?
> If so, is it an exact match, or a substring match
> or what ?
>
> --
> Jonathan Lewis
Received on Wed Apr 10 2002 - 08:54:15 CDT