Re: Normalization of attributes

Sounds like you may be able
to apply the following feature
(running on 8.0.4). You may need
suitable indices and hints to get
the optimum performance for your
specific requirement.

SQL> create table t1 as (select 'abc' v1 from dual);

Table created.

SQL> create table t2 as (select 'abcd' v1 from dual);

Table created.

SQL> select * from t1, t2
  2 where t2.v1 like t1.v1 || '%';

V1 V1
--- ----
abc abcd

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Peter Balon wrote in message <38276336.D58B7313_at_stud.uni-frankfurt.de>...
>
>Well, yes and no. 'abcxx' and 'abcyy' should be treated as same entries,
>but in practice there should be no such combination.
>We can assume that the prefix from T1 will be fully in T2 and vice
>versa, so >that 'abc' match 'abcxx'.
>
Received on Thu Nov 11 1999 - 03:24:38 CST