CODEWITHSUNDEEP
oracle-databasetoad
Revious
Revious

Reputation: 8156

Extract report from multiple queries with Toad from Oracle

Is it possible to extract an Excel with multiple dataset populated from multiple queries? I need to get a report.

Currently I launch every query and I extract the resultset in a separate excel.

Upvotes: 3

Views: 1533

Answers (2)

chinna_82
chinna_82

Reputation: 6403

http://www.databasejournal.com/features/oracle/article.php/10893_3358411_3/Connecting-with-Oracle-Accessing-Oracle-via-Access-and-Excel.htm. You cac connect to oracle from Excel and view the data from excel.

Upvotes: 1

Dan A.
Dan A.

Reputation: 2924

Yes. If you use the "Excel Instance" export option, TOAD checks to see if an instance of Excel is already open. If so, it writes to a new sheet in that instance. If you've selected the "Start at active cell" option, it starts at the active cell rather than a new sheet.

Upvotes: 1

Related Questions