Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Pune
    Posts
    2

    Question Unanswered: Outer joins in oracle 8

    hi,
    i have to implement the following
    select ...
    from a left outer join b
    on (conditions including an or.....x)
    left outer join c
    on (conditions including an or.....y)
    where
    conditions ......z

    8i doesnot directly support outer joins we need
    also or operators are not supported

    i am trying the following
    select ...
    from a,b,c
    where
    x and y and z


    are the two queries equivalent?
    (though the or creates problem)
    any workaround for the or operator?

    regards

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Outer joins in oracle 8

    Yes, this has always been a problem with Oracle outer joins. One work around, which gets clumsy if there are many such outer joins in a query, is to transform from:

    select a.x, b.y
    from a, b
    where a.x = b.x (+) or ...

    to:

    select a.x, b.y
    from a, b
    where a.x = b.x or ...
    UNION
    select a.x, NULL
    from a
    where not exists (select 1 from b where a.x = b.x or ...);

Posting Permissions

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