Re: Need oracle expert - SQL
Date: Sun, 2 Mar 2008 19:40:52 -0800 (PST)
Message-ID: <50aaebb1-bb73-444c-971a-1eba7c036a83@d62g2000hsf.googlegroups.com>
On Mar 2, 4:18 pm, marfi95 <marf..._at_yahoo.com> wrote:
> All,
>
> I am in need of some expert oracle advice on how to solve the
> following problem. Any ideas would be most helpful.
>
> What I need to do is find duplicate rows in 2 joined tables (just
> certain columns are checked for dup, not all) and
> return information from both tables on a single row. However, my
> requirement is not just to report the duplicate data, but to report
> other data from the two tables as well. The problem I run into is
> that I need to return the data on a single row back to my application
> in a ref cursor, but table 2 can have multiple rows per table 1 based
> on the join. So, the original record could have more rows (because of
> table 2) than the duplicate or the other way. I need to report both
> back to the user.
See possible answer in comp.databases.oracle.server.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Received on Sun Mar 02 2008 - 21:40:52 CST