Re: ORA-01719 - experiences please
From: Ken Friday <ken.friday_at_teldta.com>
Date: 1996/02/14
Message-ID: <4ft5vh$qtv_at_madison.tdsnet.com>#1/1
Received on Wed Feb 14 1996 - 00:00:00 CET
Date: 1996/02/14
Message-ID: <4ft5vh$qtv_at_madison.tdsnet.com>#1/1
Martin,
I would suggest removing the outer join syntax from the literal comparison and using NVL.
e.g. NVL(b.column2,'Whatever') in ('A','B')
I don't think outer joins against literals makes logical sense. Correct me if I'm wrong but the predicate will always be true since (+) means to provide a null row even it there's not a match.
Ken F.
--
--
Received on Wed Feb 14 1996 - 00:00:00 CET