RE: Any One have any insight?????

From: Hatzistavrou Giannis <j.hatzistavrou_at_telesoft.gr>
Date: Fri, 6 Oct 2000 10:00:50 +0300
Message-Id: <10641.118666@fatcity.com>

I believe he/she is trying to take care of duplicates.

> -----Original Message-----
> From: Christine Turner [SMTP:christine.turner_at_ips-sendero.com]
> Sent: =D0=DD=EC=F0=F4=E7, 5 =CF=EA=F4=F9=E2=F1=DF=EF=F5 2000 6:27 =
=EC=EC
> To: Multiple recipients of list ORACLE-L
> Subject: Any One have any insight?????

>=20

> Good Morning All.....

>=20
> Listed below is a block of code from a pl\sql procedure that I'm not =
sure=20
> what the developer was trying to accomplish. I know this is easy, =
but
> it's=20
> one of those "looked at it too long to see the answer" situations. =
Anyone
>=20
> have any ideas as to why the developer was using rowid in this insert =

> statement????

>=20


>            insert into temp_big_gllist (glacct, desct)

>            select distinct (gl_acct_no), (description) from =

usrtblname


>            t1 where t1.rowid =3D (select min(t2.rowid) from =

v_usrtblname


>            t2 where t1.gl_acct_no =3D t2.gl_acct_no);

>=20
>=20

> Any comments are appreciated!!!!!
> Thanks,
> Christine Turner
> DBA
> IPS Sendero
> Scottsdale, Arizona

>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Christine Turner
> INET: christine.turner_at_ips-sendero.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 06 2000 - 02:00:50 CDT