Explain Plan with CTRL+E gives error "ORA-00933: SQL Command not properly ended" (4297441)

User has a Editor window with multiple SQL statements. In previous versions of Toad, a user can place the cursor on a statement and press Ctrl+E to bring up an explain plan. Doing this in Toad 9.0 gives an error "ORA-00933: SQL Command not properly ended."

Toad for Oracle 9.0's Editor was rebuilt from the ground up in order to support many other new features. With this, the ability to run an explain plan on lines of SQL that do not have semi-colons has been disabled.

WORKAROUND 1:

Every SQL statement should have a semi-colon to properly end the statement. If your SQL statements have semi-colons, the CTRL+E for explain plans will work.

WORKAROUND 2:

Highlight the entire statement you wish to run an explain plan on, then press CTRL+E.

WORKAROUND 3:

Use CTRL+H to select current statement before plan.


STATUS:

Enhancement request QCM 31060 has been submitted to Development for consideration in a future release of Toad for Oracle.