Toad World® Forums

Toad 12.10.0.30 - F9 and Shift-F9 Do the Same Thing

Hello,

Using Toad 12.5.1.1 I used to be able to have a statement like this:

Select ‘B’,
rowNum
From dual
connect by level <= 5

union all

Select ‘A’,
rowNum
From dual
connect by level <= 5;

If I place my cursor on the B in Select ‘B’ and pressed I would get the whole union statement and press and only get the “B” section.

e.g.

With Toad 12.5.1.1

‘B’ ROWNUM
B 1
B 2
B 3
B 4
B 5
A 1
A 2
A 3
A 4
A 5

With Toad 12.5.1.1

‘B’ ROWNUM
B 1
B 2
B 3
B 4
B 5

But with Toad 12.10.0.30 when press or I only get the B statement in the results.

e.g.

‘B’ ROWNUM
B 1
B 2
B 3
B 4
B 5

I have the checked Toad Options and it looks like they are set correctly:

Toad_Options.jpeg

Disable the “Treat blank line as statement terminator” option on the Execute/Compile page in Options. This option should not have been enabled by default. Starting in 12.11 the default for new installs is disabled to ease confusion.

Thank you! Thank you! Thank you!