Re: Binary or Hash search in plsql table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 10 Apr 2002 13:47:55 +0100
Message-ID: <1018442805.26829.0.nnrp-14.9e984b29@news.demon.co.uk>

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
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Sunil wrote in message ...


>Joining is ruled out because of the limitations on Long columns.

>-

>Sunil.

>

Received on Wed Apr 10 2002 - 07:47:55 CDT