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


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

Original text of this message