Recent content by SJM

The program window is not parsing correctly when an IF statement includes a CASE statement. The code intermittently fails with "Unable to complete operation due to errors in source code", and the Code Contents pane does not display anything. In the sample code below, everything works fine if...

I agree, it should be an option, specifically for that reason. I'd like to see DBMS_XPLAN be the default, though :)

Can we get an option to have the Explain Plan feature return output from DBMS_XPLAN.DISPLAY rather than the current grid? To me the output is more readable in this format, and any enhancements in newer versions of Oracle would automatically be supported.