So, title: How to show all results in result set besides spamming Alt + PgDn)


Is there another way besides exporting to excel/csv and then opening it?


Another question would be if I don't have that many columns, could we choose to display multiple pages of a result set, side by side? Like looking at a book, you'd have 1-25 on pg1, 26-50 on pg2.

Is Alt+End not working for you to fetch last page?

Regards

Maxim

Regarding your second question - i think the most similar approach would be to put the query 2 (or more if required) times into sql window, run it and then select 2 result set tabs (by Ctrl+LeftClick on the tab) - it brings both tabs in foreground, both result sets can be fetched then separately and positioned by records of interest, both result sets can as well be compared (per menu item "Compare 2 result sets")

Regards

Maxim

Besides Alt-End (or the associated button on the result set toolbar) there are 2 other methods:

1. Specify a comment directive before the query:

-- records = all
select * from all_objects;

2. Set the "Records per page" preference (Preferences > SQL Window) to "All records". Now all queries will automatically fetch all records.

Thank you for the assistance, all!