Export All Records from Query

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
par20pinspot
Posts: 1
Joined: Fri 04 Sep 2015 17:46

Export All Records from Query

Post by par20pinspot » Fri 04 Sep 2015 18:06

I am trying to export all records from the result of a query. I know that turning off pagination is one way, but the results of my query has >1 million rows. I'm sure I could do this outside of dbForge studio, but wondering if there is any other way. Thanks

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Export All Records from Query

Post by alexa » Mon 07 Sep 2015 11:04

You can create a view based on the query the result of which you want to export, then right-click the view in Database Explorer, select 'Export Data...' and complete the wizard.

This way there is no need to retrieve data to Data Editor prior to exporting it.

Post Reply