The issue of the cursor jumping to the middle of a statement, or query, is observed in the following scenario in Toad 9.6 and 9.7:
1. Open the Editor in Toad.
2. Type in "select * from v$parameter;"
3. If you execute it using F9, everything is fine and the cursor remains at the end of the semi-colon.
4. Delete the semi-colon and add the following
where name = 'event';
5. Press F9 again and notice how the cursor does not stay at the end of the semi-colon but jumps to the middle.
Also, cursor inconsistent jump has been seen executing simple query like the following scenario using F5. The cursor has been observed to jump in any of the following four places represented by |.
SE | LECT * FROM employees;
| SELECT * FROM employees;
SELECT | * FROM employees;
SELECT * FROM | employees;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.