Home » SQL & PL/SQL » SQL & PL/SQL » full outer join
full outer join [message #22295] Wed, 02 October 2002 23:59 Go to next message
Hiren
Messages: 29
Registered: September 2002
Junior Member
how can i perform full outer join in Oracle 8.O
i.e
using (+) operator on either side is right outer join and left outer join
but (+) on both sides is not allowed Why ?
Re: full outer join [message #22313 is a reply to message #22295] Thu, 03 October 2002 09:14 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
A full outer join is not supported until 9i.
Re: full outer join [message #23432 is a reply to message #22295] Sun, 08 December 2002 22:25 Go to previous message
Loganathan
Messages: 2
Registered: October 2001
Junior Member
Pls go thru the link u will get clarified about all type of joins

http://www.oreillynet.com/pub/a/network/2002/04/23/fulljoin.html
Previous Topic: PL/SQL output formatting question/problem...please help
Next Topic: Invalid Number
Goto Forum:
  


Current Time: Thu May 16 10:46:29 CDT 2024