Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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 = 7782
returns 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
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Toad for Oracle
Topic(s):
Technical Solutions
Article History:
Created on: 9/29/2010 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
