Re: SELECT DISTINCT and Insert. Interesting question

look at the two rows
f1 = 'a', f2 = 'bc'
f1 = 'ab', f2 = 'c'

they are distinct, but
f1 || f2 are the same.

mr

Srini wrote:
> Hi,
>
> Here is an interesting question seeking for expert's advice.
>
> SELECT DISTINCT f1, f2, f3 ...
> INTO v1, v2, v3....
> FROM t1, t2....
> WHERE t1.f1 = t2.f1 ....
> ORDER BY t1.f1;
>
> Now I'm trying dump the result into a Temporary table [has only one
> coulmn varchar2(255)] like:
>
> INSERT INTO temp_table(f1) values (v1 || v2 || v3....)
>
> If the 'f1' in 'temp_table' is the Primary Key, I'm getting Unique
> Constraint error. I was expecting the SELECT DISTINCT to return
> unique row.
>
> Any clue what am I doing wrong here.
> Appreciate your valuable time.
>
> Srini.
Received on Thu Nov 07 2002 - 01:18:33 CST