Re: What does this mean (+)
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 7 Nov 2001 11:43:25 +0100
Message-ID: <tui531me2vsg44_at_corp.supernews.com>
Date: Wed, 7 Nov 2001 11:43:25 +0100
Message-ID: <tui531me2vsg44_at_corp.supernews.com>
"harry" <a_at_abc.com> wrote in message
news:mi2iutkon9aen4jt721rf0915tgdipts76_at_4ax.com...
> in a where clause i.e
>
> And E.CLE_ID = R.CLE_ID(+)
>
> thanks
>
> harry
outer join.
Records existing in E do not have to exist in R.
Using the outer join records in E without a match will be shown
removing the (+) reverts this statement to an inner join: unmatched records
in E will not be shown.
Hth
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Wed Nov 07 2001 - 11:43:25 CET