Re: Any One have any insight?????

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Fri, 6 Oct 2000 11:26:40 -0400
Message-Id: <10641.118692@fatcity.com>

Christine Turner <christine.turner_at_ips-sendero.com> on 10/05/2000 11:26:44 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Chaim Katz/Completions/Bombardier)

Subject: Any One have any insight?????

They are trying to choose a desct for a glacct. In other words, the table usrtblname has more than one row with the same glacct but these rows have different desct. To get a unique acct number and description, they are picking the first description (the row with the min(rowid) for that account no)

hth
chaim

Good Morning All.....

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

           insert into temp_big_gllist (glacct, desct)
           select distinct (gl_acct_no), (description)
           from usrtblname t1
          where t1.rowid = (select min(t2.rowid) from v_usrtblname t2
                         where t1.gl_acct_no = t2.gl_acct_no);

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Christine Turner
  INET: christine.turner_at_ips-sendero.com

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 - 10:26:40 CDT