var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Full outer join
How can i write a full outer join in Oracle.
Can anyone help me
You do not need a parachute to skydive. You only need a parachute to skydive twice.
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.
Thanks a lot
But i couldn't find syntex for full outer join
I have two tables
C1 C1 C2
1 1 101
2 3 102
3 4 103
4 6 105
5 8 106
Just I want the syntax for full outer join
I tried with Left and Right Outer Joins( Usint + signs). Its working fine.In Sql i can include full outer join Full JOIN.
Like Select A.C1,B.C2 from T1 A Full Join T2 B on A.C1=B.C1
Thanks a lot bill -- Reply
Please Reply with the full outer join syntax in oracle ----
In 8i, a full outer join would be:
select * from emp, dept where emp.deptno = dept.deptno(+)
select * from emp, dept where emp.deptno(+) = dept.deptno AND emp.deptno is
versus the 9i syntax (which does the same amount of work -- no magic there)
from SCOTT.EMP FULL outer join SCOTT.DEPT
on emp.deptno = dept.deptno
First one is working fine in oracle 8
The second one is not working in 9
Thanks a lot
That second version does work in 9i (18.104.22.168.0 anyway) - what problem do you get, and on what exact version?