Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SELECT DISTINCT and Insert. Interesting question
Srini wrote:
> Thanks... Matthias and TurkBear.
>
> I'm going to remove the primary key.
>
> Thanks for your time.
> Srini.
>
> Matthias Rogel <rogel_at_web.de> wrote in message news:<aqd449$95jhi$1_at_ID-86071.news.dfncis.de>...
> > 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.
I'm not sure what the problem is. But your proposed solution is not the correct one for any problem.
Please restate the business problem.
Daniel Morgan Received on Mon Nov 11 2002 - 10:35:28 CST