what does the + mean in the follow oracle sql code

Posted on 2011-05-06
Last Modified: 2012-05-11

Can someone explain to me what the (+) means in oracle sql line below

Question by:restockett
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    It's the old outer join syntax.
    LVL 42

    Accepted Solution

    If it's part of an Oracle SQL query, then it means outer join:
    left side of a right join
    right side of a left join

    In this case, you are joining to a literal, so I don't think it has any effect
    LVL 73

    Expert Comment

    the fact that it's compared to a literal doesn't matter.

    if you can post the rest of your query we can help
    reformat it to ANSI syntax from the Oracle syntax

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now