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:
