Results 1 to 7 of 7

Thread: Full outer join

  1. #1
    Join Date
    Jan 2005
    Posts
    5

    Unanswered: Full outer join

    How can i write a full outer join in Oracle.
    Can anyone help me

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Jan 2005
    Posts
    5

    Thanks a lot

    But i couldn't find syntex for full outer join

    I have two tables
    T1 T2
    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 ----

  5. #5
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73
    From AskTom

    In 8i, a full outer join would be:

    Code:
    select * from emp, dept where emp.deptno = dept.deptno(+)
    UNION ALL
    select * from emp, dept where emp.deptno(+) = dept.deptno AND emp.deptno is 
    null;
    versus the 9i syntax (which does the same amount of work -- no magic there)

    Code:
    select *
      from SCOTT.EMP FULL outer join SCOTT.DEPT
        on emp.deptno = dept.deptno

  6. #6
    Join Date
    Jan 2005
    Posts
    5

    Thank you

    Hi
    First one is working fine in oracle 8

    The second one is not working in 9

    Thanks a lot
    ................

  7. #7
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    That second version does work in 9i (9.2.0.4.0 anyway) - what problem do you get, and on what exact version?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •