Re: Need oracle expert - SQL

From: Charles Hooper <hooperc2000_at_yahoo.com>
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

Original text of this message