Return
-
Title
EDIT not filtering by predicates in the Editor -
Description
When running EDIT with a predicate in the editor, Toad is no longer filtering by the results by the predicate, instead ALL rows in the table being EDITed are being returned.
For example:edit scott.emp
WHERE empno = 7782returns all rows in the table, instead of just the one result suggested in the script.
Also, if the cursor is on line 2 of this script, when the statement is run, a message 'Invalid SQL Statement' will appear. -
Resolution
WORKAROUND:
Ensure the statement is written all on one row.e.g:
edit scott.emp WHERE empno = 7782
STATUS:
Waiting for fix in a future release of Toad for Oracle -
Defect ID
ST 78624