Outer Joins and Oracle 11g?

[Steve K]

I'm not sure if this is an issue with Oracle 11g or PL/SQL Developer 9, but I have some SQL written in a previous version of PL/SQL Developer that used to work fine. Now when I run it, it returns a value for every sub-query in which I am doing an outer join, even when it is not supposed to. And I've noticed this with new SQL I've been writing in v.9.

I can post my code, but I wanted to check first to see if this is a common issue that others have already solved. Thanks!

 

[Marco Kalter]

This should not be a PL/SQL Developer issue. It just sends the SQL to the server and displays the results.

 

[Steve K]

Well, the only reason I bring my question here is because I cut and pasted the offending SQL into a reporting tool, and it pulled the data with no issues. But then when I tried this yesterday, I got the same bad results in both tools, so maybe it's the person writing the SQL. :-(

 

[Ivan C.]

Steve,
In your first post you say that you're not sure it it's Oracle 11g or PL/SQL Developer 9 that's causing the issue?

Have you tried running the same SQL from SQL*Plus?
If it returns the same result as in PL/SQL Developer does, then it's not an issue with PL/SQL Developer.

Who knows what the "reporting tool" does with values coming from the outer joined tables/sub-queries? Maybe that tool was "set" to display the result in a "special" way...

 

[Steve K]

Thanks, Ivan! I don't think it's the other tool, but it is interesting that the same code would work in one place and not the other. You know, with the tools I've had available to me I've never felt the need to even use SQL*Plus! I'll give that a shot!

In the meantime, I've tweaked one of my sub-queries and have been successful getting that not to return values for every row. So now I just need to get the second sub-query to work right.

Steve