Recent content by 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...

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. :-(

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...