Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> left outer join

left outer join

From: livanojito <lojito_at_mccain.ca>
Date: 7 Feb 2003 11:54:36 -0800
Message-ID: <5058550.0302071154.682915cf@posting.google.com>


Hi guys,
In Oracle 8.* can I have the following condition while doing a left outer join
 where rtrim(t1.c1)=rtrim(t2.c2)(+) becuase I got the message "ERROR at line 30:
ORA-00907: missing right parenthesis" and if I code where rtrim(t1.c1)=t2.c2(+) then it works.

Thanks Received on Fri Feb 07 2003 - 13:54:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US