Hi
I am executing a query that is returning 486K records. Selecting Control-End to go to the last record. Then doing Right Click > Count Rows. Record count is matching the record number of the last row.
I am then Exporting the data into an xlsx file. The exported file has one more record than Count Rows displayed on the screen.
I need to collect screenshots and the export file for audit purposes - and all the figures should match, and this is the first time I am seeing this discrepancy. Only thing is after executing the query I waited for a while (because I had to execute a number of other queries from different sessions before collecting the screenshots and data) before taking the screenshots and exporting the data.
I assume this can only happen if SQL Developer is internally executing the query when exporting rather than exporting the data displayed in the grid - I tried replicating the issue without success.
Query: Is it possible that record count in exported file to be different from Count Rows in the the output grid and how to replicate the issue.
Version 4.1.4.21 Build MAIN-21.21
Thanks in advance
Regards
Sanjay