Hello,
Using version 5.1.6.
I used a SQL statemnt with the new 9i "sub-query factoring" like:
with qry1 as (select ....)
select ...
When I tried to get the plan window using (F5) or the menu option nothing happend.
Is that a bug?
There is indeed no explicit support for this statement type. You need to copy the SQL text, create a new Explain Plan Window, paste it, and execute the explain plan. We'll add this in an upcoming 6.0.x release.