Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Extract all records from a query

User_5BMQVApr 4 2022

Hi,
Perhaps I am blind but I would like to know how to extract ALL the results from a query. I mean, I know the max rows shows the limit of the rows Visual Code is showing (to avoid memory/time consumption problems) but for instance, if we have a SQL query which has more than 1000 results, how can I export all the rows?
The CSV output only exports the lines shown in Visual Code, for example, in the previous example of a total of 1000 lines, it shows only 50, it will only export those 50 records.
Sorry if the question is very newbie.
Thanks and kind regards!

Comments
Post Details
Added on Apr 4 2022
2 comments
2,323 views