Suggestion: filtering results

[ScottMattes]

I am analyzing a large, multi-union query, comparing outputs. I needed to find if a certain value was in the result set. I didn't want to modify the query to look for that value (and then have to change the query back), or any of the other ways. I opt'd for selecting all columns and all rows by clicking the top left button of the results and then right clicking and Copy to Excel, where I used column filtering.

Does PLSD have that feature in versions after 7? if not, I think that it would be a great feature to emulate Excel's filtering.

 

[Marco Kalter]

The current PL/SQL Developer version allows you to search in the result set grid.

 

[Maxmix]

'Whole words only' does not work as expected.
Searching for '0007' within 50000 rowset takes a minute on Corei7 and finds a cell containing '@.379-0007' where @ - is a cyrillic character (which this forum board cannot reproduce).

Of course, the feature is very handy for small datasets.