When doing an "explain plan for" for a MERGE statement, the editor shows an error, so I have to execute it through sqlplus. Other DML statements seem to work fine.

Toad for Oracle Xpert (64-bit)
Add-Ons: DB Admin Module

Hi Robert,

Thanks. I can reproduce that. Our parser doesn't recognize that syntax. I'll log it and we'll get it fixed soon.

FYI, the easiest way to get an explain plan in Toad is just to do a CTRL+E on the statement itself (no need to manually run the "explain plan for..." statement.


Thanks John, I learned something new.

1 Like