Using Toad for Oracle 13.1.0.78 (Toad for Oracle Xpert (64-bit)) on Windows 10, I see a weird error when trying to Execute Snippet if the last line of the snippet includes a tab. The code Oracle tries to execute cuts the last line of the statement off at some arbitrary point.
Using either Shift+F9 or Execute Snippet from the Editor drop down menu:
select[tab]'a'
from[tab]dual
Returns ORA-00942: table or view does not exist. In the query viewer, I can see that the query Oracle tried to execute is sometimes:
select 'a'
from du
and sometimes:
select 'a'
from d
If I write the same query with no tabs and Execute Snippet:
select 'a'
from dual
executes with no problem.
If it's the only code in the editor, Execute Statement (or F9) will execute it without problem regardless of tabs and spacing. If I switch the tab mode from Tab to Smart, Execute Snippet will work if the statement includes tabs, but Smart tab functionality isn't actually very smart and doesn't format code the way I want.
Is there a way I can have both Tabs and Execute Snippet working at the same time?