Home » SQL & PL/SQL » SQL & PL/SQL » full outer join (oracle 9i)
full outer join [message #320150] Wed, 14 May 2008 03:18 Go to next message
sharathmpatil
Messages: 38
Registered: February 2008
Location: Bangalore
Member

Hi,
Can we write a full outer join using oracle properitory join syntax?

Regards,
Sharath
Re: full outer join [message #320154 is a reply to message #320150] Wed, 14 May 2008 03:29 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
No. Full outer join is only available with the ANSI syntax

Ross Leishman
Re: full outer join [message #320161 is a reply to message #320154] Wed, 14 May 2008 03:40 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can get the same data by joining a normal outer join to a query that returns the other unmatched rows.
icon10.gif  Re: full outer join [message #320174 is a reply to message #320161] Wed, 14 May 2008 04:30 Go to previous messageGo to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member



Hi,

Can we implement the full outer join this way:

SELECT e.emp_id, e.emp_name, d.dept_no
FROM employees e, department d
WHERE e.dept_no = d.dept_no(+)
UNION ALL
SELECT e.emp_id, e.emp_name, d.dept_no
FROM employees e, department d
WHERE e.dept_no(+) = d.dept_no

Thanks,
Priya.

Re: full outer join [message #320183 is a reply to message #320174] Wed, 14 May 2008 04:42 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Previous Topic: doubt on joins
Next Topic: getting error when calling procedure
Goto Forum:
  


Current Time: Sat Dec 10 05:07:51 CST 2016

Total time taken to generate the page: 0.05044 seconds