Export All Records from Query

Export All Records from Query

Postby 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
par20pinspot
 
Posts: 1
Joined: Fri 04 Sep 2015 17:46

Re: Export All Records from Query

Postby 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.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle