Friday, July 25, 2003, 6:39:35 AM, you wrote:
RC not very slick but I used MINUS yesterday to find parents with no
RC children so as to purge them
Offhand, I'd think you could do this without using MINUS.
Maybe I'm wrong. But assuming there is a non-MINUS solution,
what led you to choose to
Friday, July 25, 2003, 6:39:35 AM, Rachel wrote:
RC not very slick but I used MINUS yesterday to find parents with no
RC children so as to purge them
Rachel, you make me very glad I have two kids. Please don't
purge me, ok? grin
Best regards,
Jonathan Gennick --- Brighten the corner where
I'd purge myself first 'cause I don't have kids.
Like the bad joke After I kill myself I'm turning the gun on you
--- Jonathan Gennick [EMAIL PROTECTED] wrote:
Friday, July 25, 2003, 6:39:35 AM, Rachel wrote:
RC not very slick but I used MINUS yesterday to find parents with no
RC children
where will you publish this? Id like to read your results.
From: Jonathan Gennick [EMAIL PROTECTED]
Date: 2003/07/25 Fri AM 10:04:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re[2]: Union quries: INTERSECT, MINUS, etc
Friday, July 25, 2003, 6:39:35 AM
okay, I answered this offlist but...
it started out as do we have a problem, indicated by records in the
parent table with no children
select id from parent
minus
select parentid from child
that identified that we had a problem.
next step (I'm a paranoid DBA when it comes to permanently
by: [EMAIL PROTECTED]
26-07-2003 12:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Re[2]: Union quries: INTERSECT, MINUS, etc
okay, I answered this offlist but...
it started out as do we have
Thursday, July 24, 2003, 10:09:25 AM, Dave wrote:
DP Compared actual result set
DP with expected result set via minus.
I've done that too. I need to search the cobwebs of my
memory a bit, but I recall having use MINUS both ways to be
sure:
results MINUS expected_results
tells you whether the