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

From: <dgoulet_at_vicr.com>
Date: Thu, 5 Oct 2000 11:51:29 -0400
Message-Id: <10640.118605@fatcity.com>

HUMM, looks like a case where there can be multiple entries for one gl_acct_no in usrtblname. Problem is that min(t2.rowid) will never equal t1.rowid since their seperate tables (remember rowid's are totally unique across the entire database). That is unless v_usrtblname is a view of usrtblname in which case why???

Dick Goulet

____________________Reply Separator____________________

Subject: Any One have any insight????? Author: Christine Turner <christine.turner_at_ips-sendero.com> Date: 10/5/00 7:26 AM

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 Thu Oct 05 2000 - 10:51:29 CDT