Re: SELECT DISTINCT and Insert. Interesting question

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Wed, 06 Nov 2002 11:23:59 -0600
Message-ID: <dnjisu8qta6jvm6rp0d1pdhdviblbgemrq@4ax.com>

Just a thought..
There may be embedded spaces at the end of some of the fields so the 'distinctness' is lost when concatenated .. Try
Insert into temp_table(f1) values (trim(v1)||trim(v2)||trim(v3)...)

It may resolve it...

sriniksk_at_yahoo.com (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.

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Nov 06 2002 - 11:23:59 CST